PeopleSoft Application Engine/PeopleCode - Accel. Rel 8.53 (Training On Demand)

Course Details
Code: D101131GC10
Tuition (USD): $7,335.00 $6,968.25 • Self Paced (5 days)
Generate a quote
This course is available in other formats
Instructor-Led Classroom & Virtual
PeopleSoft Application Engine/PeopleCode - Accel. Rel 8.53 (D80717GC10)

This PeopleSoft Application Engine/PeopleCode - Accel. Rel 8.53 training helps you develop the skills use Application Engine to execute existing programs, modify existing programs and create new programs. Expert Oracle University instructors will help you explore PeopleSoft Application Engine; you'll develop the skills to program batch solutions to manage the data in a PeopleSoft database.

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 SQL, PeopleCode and flow controls to solve business-based batch processing requirements.
  • Use Application Engine to create new programs.
  • Use File Layouts.
  • Use essential tools to work with Object-Oriented PeopleCode.
  • Write, edit and debug PeopleCode programs.
  • Manipulate data in the component buffer.
  • Create, use and extend application classes.
  • Write a program that incorporates the principles you learned in the course and charting.

Benefits to You

By enrolling in this course, you'll also learn how to effectively manage and develop PeopleSoft applications to respond faster to organization's business requirements. You'll develop the troubleshooting knowledge of peoplecode. This knowledge will help you further enhance the functionality of your PeopleSoft applications.

Work with Object-Oriented PeopleCode

The PeopleCode portion of the course teaches you the essential tools to work with object-oriented PeopleCode. You'll actively build programming skills in a PeopleSoft environment. The tools and skills learned in this course help you understand the structure of PeopleCode, while preparing you to move on to more advanced applications.

Build in a PeopleSoft Environment

Throughout this course, you'll actively build programming skills in a PeopleSoft environment.

Please Note

This course covers the content of the Application Engine and Peoplecode Rel 8.53 courses. Please see the individual course descriptions for a comprehensive list of the topics covered.

Skills Gained

  • Use data buffer methods
  • Use the Application Engine Designer to write, test, and debug Application Engine programs
  • Execute SQL in PeopleCode
  • Use PeopleCode development tools
  • Write PeopleCode programs
  • Explain the component buffer
  • Access data in the component buffer
  • Application class
  • Charting
  • Describe the Component Processor
  • Monitor and tune Application Engine performance
  • Develop robust Application Engine programs
  • Schedule the automatic execution of Application Engine programs
  • Use File Layouts
  • Reference data in the component buffer
  • Create custom objects with application classes

Who Can Benefit

  • Application Developers
  • Database Designers
  • Developer
  • Reports Developer
  • Support Engineer
  • Technical Consultant


  • Programming experience, preferably in an object-oriented language.
  • Experience developing PeopleSoft applications.
  • Working knowledge of the PeopleTools development environment.
  • Basic understanding of PeopleCode
  • Experience with general batch processing tools
  • Comfortable with PeopleSoft parent/child relationships.

Course Details

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

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 PeopleCode Development Tools

  • Describing the PeopleSoft Application Development Steps
  • Locating PeopleCode Programs
  • Using the PeopleCode Editor
  • Using the PeopleCode Debugger
  • Describing Additional Development Tools

Understanding the Component Processor and PeopleCode Events

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

Writing PeopleCode Programs

  • Writing PeopleCode Statements
  • Writing Conditional Statements
  • Writing Looping Statements

Using PeopleCode Variables

  • Creating User-Defined PeopleCode Variables
  • Using System Variables
  • Incorporating Derived/Work Fields into Your Applications
  • Describing Contextual Prompt Table Edits

Using PeopleCode Built-In Functions

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

Writing User-Defined Functions

  • Writing External User-Defined Functions
  • Declaring User-Defined Functions
  • Calling User-Defined Functions
  • Defining Functions Using Parameters
  • Defining Functions Using a Returns Clause

Explaining the Component Buffer

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

Programming With Object-Oriented PeopleCode

  • Defining Object-Oriented Terms
  • Instantiating Objects
  • Referencing Properties by Using Dot Notation
  • Invoking Methods by Using Dot Notation
  • Discussing Passing Objects by Reference
  • Using Methods and Properties of the Component Buffer Classes

Creating and Using Application Classes

  • Describing Application Classes
  • Organizing Application Classes Using Application Packages
  • Using the PeopleCode Editor to Create and Modify Application Classes
  • Describing the Structure of Application Classes
  • Using Application Classes
  • Passing Parameters to Methods

Executing SQL in PeopleCode

  • Writing SQLExec Statements
  • Creating SQL Definitions
  • Using the SQL Class and SQL Objects
  • Incorporating Meta-SQL in PeopleCode and SQL Definitions
  • Executing SQL Using Record Objects

Using PeopleCode to Create Charts

  • Identifying the PeopleCode Charting Classes
  • Explaining Chart Elements
  • Creating Charts