WHAT YOU WILL LEARN This course explains the Application Engine features and activities to implement in Application Designer through SQL, PeopleCode and Program Control actions. Features include peoplecode with Application Engine, Test and debug, temporary tables, PSDaemon, Application Engine Programs, File Layouts, Application Engine performance. Learn To: Use PeopleCode with Application Engine Test and Debug Use temporary tables Use PSDaemon Tune Application Engine programs Use File Layouts Measure Application Engine performance.
AUDIENCE
Application Developers Developer System Administrator System Analysts Technical Administrator
Describing the Function of State Records Creating a State Record Executing an Application Engine Program Using the Developer's Shortcut Modifying Application Engine Programs to use State Records Adding Sections and Steps to Existing Application Engine Programs Using Meta-SQL in Application Engine Programs
Module 4 - Testing and Debugging
Testing Application Engine Programs Using Process Monitor Using Application Engine Traces Using the Application Engine Debugger Testing With Application Engine Restart
Module 5 - Using the Do Select Action
This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises
COURSE OBJECTIVES
Upon completion of this program, participants should be able to: Use PeopleCode with Application Engine Test and Debug Use temporary tables Use PSDaemon Tune Application Engine programs Use File Layouts Measure Application Engine performance.
Describing Student Workstation Resources Executing an Application Engine Program Using Application Engine Designer Describing Application Engine Program Structure Building Application Engine Programs Adding Markets and Filters to Application Engine Program Sections Setting Application Engine Program Properties Testing Application Engine Programs
Module 3 - Using State Records
METHODOLOGY
Describing Application Engine Features Describing Application Engine Benefits Finding Information About PeopleSoft Application Engine in PeopleBooks
Describing Do Select Using Select and Fetch Using Reselect Using Restartable Developing an Application Engine Program Using Do Select Building PSU_CRS_INS
Module 6 Processing
-
Incorporating
Conditional
Defining Do Actions Explaining Conditional Statements in SQL Explaining Do Action Program Flow Designing a Program Using Conditional Processing Using Application Engine Libraries
PEOPLESOFT APPLICATION ENGINE REL 8.53| Page 1 of 2 160317
Module 7 - Using PeopleCode with Application Engine
Identifying How to use PeopleCode in Application Engine Programs Inserting PeopleCode into an Application Engine Program Enabling Dynamic Calls
Module 8 – Using Set Processing
Describing Set Processing Modifying a Program to use Set Processing Describing Parallel Processing Implementing Parallel Processing Using Meta-SQL with Parallel Processing Describing Run-Time Allocation
Describing PSDAEMON Describing a Daemon-Only Program Defining Daemon Groups Monitoring a Daemon Process
Listing Ways to Execute Application Engine Programs Executing an Application Program with the Process Scheduler Executing an Application Engine Program with a Command Script
Application
Engine
Module 14 - Measuring Application Engine Performance Describing Traces Passing Trace Values to PSAE.EXE Interpreting Application Engine Trace Data Interpreting the PeopleTools Trace Describing Advanced Trace Options
Describing the Process of Performance Tuning Identifying Application Level Tuning Opportunities Explaining the Performance Impact of PeopleCode Describing How Do Flow Control Affects Program Performance Explaining Database-Level Tuning Considerations
Module 11 - Creating Process Definitions for Application Engine
Identify the Process Types used with Application Engine Creating Application Engine Process Definitions Implementing an Application Engine Program with No User Inputs Implementing an Application Engine Program With User Inputs
Module 12 - Importing Data into the PeopleSoft System Using Flat Files
Describing File Layouts Creating File Layout Definitions Importing Data Using File Layouts Running the Application Engine Program Adding Field Attributes to a File Layout
PEOPLESOFT APPLICATION ENGINE REL 8.53| Page 2 of 2 160317