PeopleSoft Application Engine Rel 8.53

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

• System Analysts
• System Administrator
• Technical Administrator
• Application Developers
• Developer

Course Topics Technology Overview

• Describing Application Engine Features
• Describing Application Engine Benefits
• Finding Information About PeopleSoft Application Engine in PeopleBooks

Introducing Application Engine Designer

• 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

Using State Records

• 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

Testing and Debugging

• Testing Application Engine Programs
• Using 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
• Building PSU_CRS_INS

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

• Listing Ways to Execute Application Engine Programs
• 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

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

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

• Use PeopleCode with Application Engine
• Test and Debug
• Use temporary tables
• Use PSDaemon
• Tune Application Engine programs
• Use File Layouts
• Measure Application Engine performance.