Application Engine

Application Engine

Application Engine 

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 An Application Engine program is a set of  SQL statements,  PeopleCode * and  Program control actions that enable looping and conditional logic) defined in PeopleSoft Application Designer that performs a business process.

Enhanced User Interface 

 

In Definition View, the definition objects are defined and maintained. Definition objects: Program, Section, Step, Actions. Program Flow View: This view shows how the flow of execution of steps , statements and actions occur at run-time

Definition View

Program View

Program Components/Elements 

Program



Sections



Steps



Do Actions (Do Select , Do While, Do Until, Do When)

Program Elements 

SQL Actions ( Insert , Update, Delete, Select )



Peoplecode *



Log Message **



Call Section **



State Record **

* Added Functionality ** Modified Functionality

Programs 

A Program is comprised of the logically ordered set of Sections, Steps, and Actions defined within it



Should have at least one section , step and action



Executable program should have a MAIN section



A E program definitions can also be stored as Application Libraries without a MAIN section

Section      

Consists of one or more steps Sections – similar to COBOL paragraphs Sections can be public or private Sections of one program could be called from same / different program Only Public sections could be called Sections could be called only through CALL SECTION action type

Steps    



Steps comprises sections Steps are comprised of Actions. Can have more than one action for a step Actions are of two types – SQL , Program Flow ( Do Actions ) Actions in a step have their order of execution

Actions 

SQL Action – UPDATE , INSERT, SELECT , DELETE



Executes Peoplecode



Program Flow Actions – Iterative and Conditional Processing of sections/actions (DO Actions)

Actions 

Maximum Number of Actions a Single Step can Contain is Seven



You can't have more than one Action of a specific type within the same Step.



You can't have a SQL Action and a Call Section Action within the same Step.

Application Engine Program Types     

Standard Upgrade Only * Import Only ** Daemon Only ** Transform Only **

Daemon-Only Type 

PeopleSoft Application Engine has a new daemon process, called PSDAEMON



Runs continuously when the Process Scheduler is running,

Transform Program Type 

These type of programs enable different systems to communicate with one another by transforming messages into appropriate formats.



When you specify an Application Engine as a Transform Only program, you must specify an Action Type of XSLT.

Meta SQL %Bind %Execute Edits %Select %SelectInit %SQL %Table %TruncateTable %UpdateStats

Test an A.E

State Record •Use to Pass the values across the Section •Name should end with _AET •PROCESS_INSTANCE is the only Key field •Multiple program can use same State Record •%SELECT construct in a SQL statement •%BIND for reference the Field

Define State Record

Temporary table •To store a transient or intermediate results during a program run •Maximum 99 temporary table instances •%Table should be used for referring table name. •PROCESS_INSTANCE field should include as one of key field. (If not then Runtime option change to ‘Abort’)

Temporary table Instance

Assigning Temporary table

Trace the A.E Program

Trace the A.E Program