PeopleSoft Application Engine Rel 8.50

This 4-day course teaches participants to use PeopleSoft Application Engine to program batch solutions to manage the data in a PeopleSoft database. Participants learn to execute and modify existing Application Engine programs, and to create new Application Engine programs. Participants will use SQL, PeopleCode, and flow controls to solve business-based batch processing requirements.

Learn To:

• Create batch solutions to manage data
• Use Application Engine as a tool for integration
• Use Application Engine to execute and modify existing programs
• Use Application Engine to create new programs

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• Application Developers
• Developer
• Support Engineer
• System Analysts
• Technical Administrator
• Technical Consultant

Course Topics Introducing Application Designer

• Describing Student Workstation Resources
• Using Application 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

Using State Records

• Describing the Function of State Records
• 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

Testing and Debugging

• Testing Application Engine Programs
• Using the Process Monitor
• Using Application Engine Traces
• Using the Application Engine Debugger
• Testing With Application Engine Restart

Using the Do Select Action

• Describing Do Select
• Using Select and Fetch
• Using Reselect
• Using Restartable
• Developing an Application Engine Program Using Do Select

Incorporating Conditional Processing

• Defining Do Actions
• Explaining Conditional Statements in SQL
• Explaining Do Action Program Flow
• Designing a Program Using Conditional Processing
• Using Application Engine Libraries

Using PeopleCode with Application Engine

• Identifying How to use PeopleCode in Application Engine Programs
• Inserting PeopleCode into an Application Engine Program
• Enabling Dynamic Calls

Using Set Processing

• Describing Set Processing
• Modifying a Program to use Set Processing

Using Temporary Tables

• Describing Parallel Processing
• Implementing Parallel Processing
• Using Meta-SQL with Parallel Processing
• Describing Run-Time Allocation

Executing Application Engine Programs

• Executing an Application Engine Program Using a Push Button
• Executing an Application Program with the Process Scheduler
• Executing an Application Engine Program with a Command Script

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

Using PSDAEMON

• Describing PSDAEMON
• Describing a Daemon-Only Application Engine Program
• Defining Daemon Groups
• Monitoring a Daemon Process

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

Tuning Application Engine Programs

• 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

Course Objectives

• Monitor and tune Application Engine performance
• Use the Application Designer to write, test, and debug Application Engine programs
• Schedule the automatic execution of Application Engine programs
• Develop robust Application Engine programs