in self service, I navigate Self Service >>> Degree Progress/Graduation >>> My Academic Requirements
there is no user interruption....but I need to insert into a table before the component pre-build is complete and the page is displayed.
I get no insert/updates allowed in prebuild. I tried to "call app engine".....but get "sql update occured...." error.
Is there a way that I can trick the prebuild.....OR....perform my select/insert PRIOR to the prebuild firing?
thanks for any suggestions.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
I think you cannot issue SQLs in PreBuild. Have you tried Page Activate?
yes, I understand db updates are not allowed. the component has a few pages. the page to be displayed is dependent on the flow (reading the tbl I want to insert) of the comp prebuild pcode. lacking data in the tbl in question, the logic steers the user to a generic page within the component. I am now considering placing a pushbutton on that generic page where I'd perform the inserts.
But I'm still interested in other options. thanks.
1) Have a CI - built for this purpose. On page activate, instantiate the CI, assign attributes and call CI's Save() method.
2) (Disgusting option) - create a local to local routing - send a message on page activate to local node. Subscribe and write code in the onNotify of subscription handler to perform the inserts.