PeopleSoft Application Engine/PeopleCode - Accel. Rel 8.50

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

This five-day course also teaches participants the essential tools to work with object-oriented PeopleCode. Participants actively build programming skills in a PeopleSoft environment. The tools and skills learned in this course ground the participants in the structure of PeopleCode and prepare them to move on to more advanced applications.

This Course helps the student to:

• Describe PeopleCode
• Use the PeopleCode development tools to write, edit, and debug PeopleCode programs
• Write PeopleCode programs and choose the events in which to place them
• Manipulate data in the component buffer
• Program with object-oriented PeopleCode
• Manipulate data in the data buffers and in SQL tables
• Write a program that incorporates the principles you learned in the course and Charting

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
• To use essential tools to work with Object-Oriented PeopleCode
• Write, Edit and Debug PeopleCode programs
• Manipulate Data in the Component Buffer

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
• Database Designers
• Developer
• Reports Developer
• Support Engineer
• Technical Consultant

Course Topics Introducing Application Engine Designer

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

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

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

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

Technology Overview

• Describing PeopleCode
• Describing How PeopleCode is Used
• Describing Where PeopleCode is used

Using PeopleCode Development Tools

• Reviewing the Eight Steps of PeopleSoft Application Development
• Locating PeopleCode Programs
• Using the PeopleCode Editor
• Using the PeopleCode Debugger
• Exploring More Development Tools

Describing the Component Processor

• Tracing the Component Processor Flow
• Defining PeopleCode Events
• Identifying the PeopleCode Search Events
• Identifying the PeopleCode Component Build Events
• Identifying the PeopleCode Field Action Events
• Identifying the PeopleCode Row Action Events
• Identifying the PeopleCode Save Action Events
• Describing Add Mode Processing

Writing PeopleCode Programs

• Defining PeopleCode Statements
• Explaining Conditional Statements
• Explaining Looping Statements

Explaining PeopleCode Events

• Explaining the Search Events
• Explaining the Component Build Events
• Explaining the Field Action Events
• Explaining the Row Action Events
• Explaining the Save Action Events

Using PeopleCode Variables

• Creating User-Defined PeopleCode Variables
• Using System Variables
• Incorporating Derived/Work Fields
• Explaining Variable Prompt Tables
• Explaining Arrays

Using Built-In Functions

• Listing Types of Built-In Functions
• Explaining Message Catalog Functions
• Describing All, None, and PriorValue
• Explaining String Functions
• Reviewing Other Built-In Functions
• Explaining Reserved Words

Writing PeopleCode Functions

• Writing External PeopleCode Functions
• Declaring PeopleCode Functions
• Calling PeopleCode Functions
• Writing Functions Using Parameters
• Writing Functions Using the Returns Argument

Explaining the Component Buffer

• Describing the Component Buffer
• Reviewing Occurs Levels
• Determining Buffer Allocation
• Determining the Order of Execution of PeopleCode Programs

Accessing Data in the Component Buffer

• Processing Rows with Loops
• Using FetchValue and UpdateValue
• Accessing Data Across Multiple Occurs Levels

Referencing Data in the Component Buffer

• Defining the Data Buffer Classes
• Instantiating the Buffer Access Classes
• Explaining Current Context
• Explaining Traversing the Data Buffer
• Using Shorthand Dot Notation
• Traversing the Data Buffer with Multiple Occurs Levels

Course Objectives

• Monitor and tune Application Engine performance
• Use the Application Engine Designer to write, test, and debug Application Engine programs
• Develop robust Application Engine programs
• Schedule the automatic execution of Application Engine programs
• Monitor and tune Application Engine performance
• Referencing data in the component buffer
• Creating custom objects with application classes
• Using data buffer methods
• Executing SQL in PeopleCode
• Using PeopleCode development tools
• Describing the Component Processor
• Writing PeopleCode programs
• Explaining the component buffer
• Accessing data in the component buffer