State Records and Missing Data May 22, 2007
Posted by Duncan in Application Engine, PeopleSoft, SQL.trackback
We've encountered an issue today that we hadn't noticed before. Within an Application Engine program we populate a state record (AET table) with values. The first time we use these values (i.e. retrieve them using %Bind()) the values are retrieved successfully, however when we attempt to use the values a second time they are empty/blank.
A state record is a PeopleSoft record that must be created and maintained by the Application Engine developer. This record defines the fields a program uses to pass values from one action to another. Think of the fields of the Application Engine state record as the working storage for your Application Engine. The Cache record (or state record) is a physical People soft record, keyed by process instance that must be created and maintained by the Application Engine developer. This record defines the fields that an application uses to pas values from one SQL statements to another. App Engine Program Elements-A PeopleSoft Application Engine program comprises the set of processes to execute a given task, and is made up of several key elements: Sections. State records; Sections:-Sections comprise one or more steps and are equivalent to a COBOL paragraph or a Structured Query Report (SQR) procedure.
This occurred because our State Record was set as a Derived/Work record and our App Engine did not have restart disabled. As a result it was performing Commits after each Section (the default behaviour), and – this is the gotcha – a commit clears down the State Record!
Welcome II Nextasy the second studio album by American R&B trio Next. It was released by Arista Records on June 20, 2000 in the United States where it reached gold status. In 2000, the group released the lead single 'Wifey' ahead of their sophomore album for Arista. The song became another #1 R&B hit for the group and also featured singer Lil' Mo on background vocals. Their sophomore album, Welcome II Nextasy, was released in June 2000 and was certified gold on the strength of the lead single. A second single. Next welcome ii nextasy songs playlist.
State Record In Application Engine Peoplesoft Search
According to PeopleBooks, this is by design. If you wish to have commits in your App Engine then your State Record must be setup as a SQL Table to keep its values.
This occurred because our State Record was set as a Derived/Work record and our App Engine did not have restart disabled. As a result it was performing Commits after each Section (the default behaviour), and – this is the gotcha – a commit clears down the State Record!
Welcome II Nextasy the second studio album by American R&B trio Next. It was released by Arista Records on June 20, 2000 in the United States where it reached gold status. In 2000, the group released the lead single 'Wifey' ahead of their sophomore album for Arista. The song became another #1 R&B hit for the group and also featured singer Lil' Mo on background vocals. Their sophomore album, Welcome II Nextasy, was released in June 2000 and was certified gold on the strength of the lead single. A second single. Next welcome ii nextasy songs playlist.
State Record In Application Engine Peoplesoft Search
According to PeopleBooks, this is by design. If you wish to have commits in your App Engine then your State Record must be setup as a SQL Table to keep its values.
This implies that you may need 2 state records for larger/more complex AEs. One SQL Table AET to hold variables that you wish to reference throughout your program, and one Dervied AET to hold values that you'll reference immediately (i.e. variables that you wish to use in Dynamic SQL, like within a DoSelect).
Oracle Peoplesoft Applications
There is a Customer Connection case explaining it further:
http://www.peoplesoft.com/psp/portprd/CUSTOMER/CRM/c/C1C_MENU.C1_SOLN_SUMMARY.GBL?page=C1_SOLN_SUMMARY&SETID=SHARE&SOLUTION_ID=201024788 Homeworld remastered collection reloaded.