SiS Technical Training Development Track

1. SiS Technical Training Development Track Day 6

2. Agenda • Understand Application Engine and Run Control Pages • Practice of Application Engine(Instructor Led)

3. Understand Application Engine Overview: • PeopleSoft Application Engine is the PeopleTool that you use to develop batch or online programs that perform high-volume, background processing against your data. • Application Engine program contains Peoplecode, SQLs and MetaSql statements. • Application Engine consists of Sections, Section contains Steps and Step contains different Actions. • AE is designed for large amount of data to be processed without user intervention.

4. Understand Application Engine • Creation of Application Engine: File-> New-> App Engine Program

5. Creation of AE: Section • All AE’S must contain at least one section entitled “MAIN”. • Section is set of steps that get executed as the part of program. • We can call the sections from steps of other sections also.

6. Creation of AE: Step • This is smallest unit of work that can be committed within the program. • We can use the Step to execute SQL, PeopleCode and to call other sections. • The SQL or PeopleCode that a step executes are the actions within the step. • When section gets called, its steps executed sequentially. • Every program starts by executing the first step of required section called MAIN and ends after the last sections last steps.

7. Creation of AE: Action • In Step there are multiple types of actions included. • Following are the types of actions: • SQL • DO(While, When, Select, Until) • PeopleCode • Call Section • Log message • XSLT(enabled for Transform only program) SQL is the default action for any step included in the section. Through the SQL we can do the insert, update, delete and select.

8. Creation of AE • Do action have 4 types: Do When Do While Do Select Do Until Use of above all actions: • Do when : If statement • Do while : While Statement • Do select : Runs for every row actions returns • Do Until : Runs after each action when step completes

9. Creation of AE • PeopleCode : validations and conditions to check in between the process • Call Section : To call another section define in application engine. • Also give call to different Application engine Section. • Log messages : to write messages i.e. Error messages or even informational messages. • SQL and Call Section mutually exclusive actions.

10. Creation of AE’s Action’s

11. Meta SQL • %Bind : %Bind returns the value of the state record field identified within its parentheses. • %Select : %Select used to pass the values to State record buffers. • %SelectInit : Same as %Select only difference is it reinitialize the buffers. • %SQL : It is used to insert the SQL object in Application engine.

12. Managing Application Engine • Program Properties of Application Engine

13. Managing Application Engine • State Record : Record unique to Application Engine and named as recordname_AET. • PROCESS_INSTANCE is the default field in State record. • Can be derived or physical(SQL Record) record.

14. Managing Application Engine • Register process of Application Engine: PeopleTools> Process Scheduler> Processes • Process Name should be same as that of application engine name.

15. Managing Application Engine

16. Managing Application Engine