About this Course

Code TPD80850GC10
Duration 5 Days
Special Notices

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

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 YouBy 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 PeopleCodeThe 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 EnvironmentThroughout this course, you'll actively build programming skills in a PeopleSoft environment.Please NoteThis 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.Live Virtual Class FormatA 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.


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

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

Delegates will learn how to

  • 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
  • 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
  • Describe the Component Processor
  • Write PeopleCode programs
  • Explain the component buffer
  • Access data in the component buffer
  • Application class
  • Charting


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

5 Days


This is a QA approved partner course

Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

Sorry, we don't have any public dates scheduled for this course, but it can be run as a closed event for your company.
Please contact us for details on alternative ways we can help you 0113 220 7150 or email us at info@qa.com.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.