Download PDF
of this course

PeopleSoft PeopleTools II Rel 8.53 (PSPT2)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 5 Days

Price: SGD 5,275.00

PeopleTools II expands on the skills acquired in PeopleTools I. In this five-day course, you'll gain advanced development and troubleshooting experience as you create applications that incorporate complex features like subrecords, subpages, style sheets, WorkCenters, dashboards, links, PeopleCode and more.

Learn To:

  • Create records and pages that maintain parent child relationships.
  • Enhance application and page functionality.
  • Create and use sub records and sub pages.
  • Create and use views.
  • Write basic PeopleCode programs.
  • Troubleshoot applications.

Benefits To You:

Expand your development and troubleshooting knowledge of PeopleTools so that you can readily incorporate complex features to further enhance the functionality of your PeopleSoft applications to better meet your organization’s business needs.

Learn from Expert Oracle University Instructors

By investing the time to take this course, you'll not only become a better user of PeopleTools; you'll also get the chance to learn straight from the experts. Oracle University instructors will teach you through hands-on demonstrations and interactive discussions that will solidify your understanding of new concepts and widen your overall skill set.

Who Should Attend

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

Course Certifications

This course is part of the following Certifications:


Required Prerequisites:

  • Working knowledge of PeopleSoft Data Organization and Validation
  • Working knowledge of PeopleSoft Architecture
  • Experience with the Eight Steps of Application Development
  • PeopleSoft PeopleTools I Rel 8.53


Course Objectives

  • Troubleshoot common problems in PeopleSoft applications
  • Apply PeopleSoft Design Methodology in developing applications
  • Create and use views as the basis for summary pages, search records, and prompt tables
  • Explain and implement table set sharing
  • Create records and pages that maintain parent child relationships
  • Explain the buffer allocation process and its impact on application performance
  • Create and use sub records and sub pages in an application
  • Write PeopleCode programs to satisfy business requirements and enhance applications
  • Enhance application and page functionality using advanced PeopleTools features, such as images, links, and deferred processing
  • Incorporate Dashboards and WorkCenters in your applications

Course Content

Developing Applications with PeopleTools

  • Designing an Application
  • Creating Data Structures
  • Creating User Interfaces
  • Testing Applications

Using Views in PeopleSoft Applications

  • Stating the Purposes of Views
  • Writing SQL Statements to Retrieve Data
  • Creating PeopleSoft SQL Views
  • Creating PeopleSoft Query Views

Creating Summary Pages Using Views

  • Explaining the Purpose of Summary Pages
  • Creating Summary Pages Based on PeopleSoft Views
  • Determining the Key Structure for a Summary View

Creating and Using Search Records

  • Explaining the Role of Search Records in Components
  • Using Views to Provide Additional Search Criteria
  • Implementing the Add Search Record in a Component

Using Views as Prompt Table Edits

  • Setting Up a Prompt Table Edit that Uses a View
  • Explaining the Mechanics of Prompting
  • Creating Views that Take Advantage of Prompting Mechanics

Explaining TableSet Sharing

  • Explaining the Functional Aspects of TableSet Sharing
  • Explaining the Technical Aspects of TableSet Sharing
  • Implementing TableSet Sharing

Creating Parent-Child Relationships

  • Explaining Methods That Enforce Referential Integrity
  • Creating Parent-Child Record Definitions
  • Enforcing Parent-Child Relationships on Page Definitions

Explaining Buffer Allocation

  • Discussing Buffer Allocation
  • Determining the Effect of Buffer Allocation on Performance

Creating Subrecords and Subpages

  • Stating the Purpose of Subrecords
  • Creating and Maintaining Subrecords
  • Stating the Purpose of Subpages
  • Creating and Maintaining Subpages
  • Identifying the Caveats for Using Subrecords and Subpages

Using Deferred Processing

  • Explaining the Purpose of the Application Server
  • Distinguishing Between Processing Modes
  • Changing the Processing Mode of a Definition

Introducing PeopleCode in an Application

  • Explaining the Purpose of PeopleCode
  • Accessing PeopleCode Programs
  • Identifying Elements of PeopleCode Syntax
  • Using PeopleCode to Validate User Input
  • Managing PeopleCode Programs Using Comments
  • Creating Error Messages Using the Message Catalog
  • Implementing FieldEdit, SaveEdit, RowInit, and Field Change PeopleCode
  • Using PeopleCode to Manipulate Fields

Using Images in PeopleSoft Applications

  • Implementing Image Definitions
  • Implementing Image Field Definitions
  • Retrieving Images with PeopleCode
  • Differentiating Between Image Definitions and Image Fields

Designing Pages Using Style Sheets

  • Viewing Relationships Among Style Sheet Elements
  • Overriding the System Style Sheet
  • Using PeopleCode to Modify the Style Property of a Field Object

Designing More Advanced Pages

  • Using the Message Catalog in Page Design
  • Creating Pages with Alternate Data Displays
  • Creating Links to Internal and External Pages
  • Creating Pop-up Pages

Configuring and Managing Dashboard and WorkCenter Pages

  • Describing Dashboard Pages
  • Creating and Configuring Dashboard Pages
  • Describing WorkCenter Pages
  • Describing and Defining WorkCenter Templates
  • Describing the Development Process for WorkCenter Pages
  • Describing the Development Process for WorkCenter Pagelets
  • Managing WorkCenter Page Configurations
  • Describing Activity Guides


Course ID: PSPT2

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register