Wednesday, September 23, 2015

State Records - PeopleSoft

Uses and Limitations :-
1. You assign variables for your Application Engine program through state records, while sections, steps, and actions pass values to subsequent program steps through state records.
2. You can have up to 200 state records associated with a particular Application Engine program.
3. Only one record can be the default state record.

Criteria to create a State Record :- 
1. It must have a process instance defined as the first field and the only key field.
2. State record name must end with _AET.
3. You can specify both work (derived) and physical (SQL table) records to be used as state records.
4. In order to implement dynamic call state record must contain fields AE_APPLID, AE_SECTION.

Meta-SQL used :- 
1. To select fields in the state record, use the %SELECT construct.
2. To reference fields in the state record, use the %BIND construct.

No comments: