PeopleSoft Application Developer II: Application Engine & Integration Exam

PeopleSoft Application Developer II: Application Engine & Integration

The PeopleSoft Application Developer II: Application Engine & Integration (1Z0-242) exam is designed for individuals who possess a strong foundation and expertise in developing, implementing and customizing PeopleSoft applications, and have passed the PeopleSoft Application Developer I: PeopleTools & PeopleCode (1Z0-241) exam.

The PeopleSoft PeopleTools Implementation Specialist certification recognizes OPN members as OPN Certified Specialists. This certification differentiates OPN members in the marketplace by providing a competitive edge through proven expertise. This certification helps the OPN member’s partner organization qualify for the PeopleSoft PeopleTools Specialization.

Exam Number:
120 minutes
Associated Certifications:
PeopleTools Advanced Developer Certified Expert

OPN Certified Specialist
of Questions:
Exam Price:
US$ 245

Pricing may vary slightly by country or by localized currency. Check Pearson VUE’s website for exact pricing in your country.
Click Here to Register:

Passing score subject to change. View Details


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
PeopleSoft Application Developer II Exam Study Guide (PDF)
OPN Guided Learning Path:
PeopleSoft PeopleTools 8.50 II Implementation Specialist
Oracle University Training:
PeopleSoft Application Engine Rel 8.50
PeopleSoft Integration Tools Rel 8.50

This exam has been validated against Rel. 8.48, 8.50 and 8.51



Additional Information & Resources

Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)
More Training Opportunities for Oracle Partners

Sample Questions



Exam Topics


Using PeopleCode Development Tools

  • Debug PeopleCode programs using Debug, trace, and Message Box

Using PeopleCode Variables

  • Configure variable prompt tables
  • Instantiate, populate, and access arrays

Referencing Data in the Component Buffer

  • Traverse the data buffer to reference multiple occurs levels

Creating Custom Objects with Application Classes

  • Use the Application Class Editor to create and modify application classes
  • Convert existing PeopleCode programs to application classes

Using Data Buffer Methods

  • Use standalone rowsets

Executing SQL in PeopleCode

  • Read and modify data tables using the SQL class and Record objects
  • Incorporate meta-SQL in PeopleCode and SQL

Application Engine

Introducing Application Engine Designer

  • Use Application Engine Designer
  • Read an Application Engine program
  • Build Application Engine programs
  • Add markets and filters to an Application Engine program

Using State Records

  • Describe the function of state records
  • Create a state record
  • Modify Application Engine programs to use state records
  • Use meta-SQL in Application Engine programs

Testing and Debugging

  • Use Process Monitor to monitor App Engine programs
  • Trace Application Engine programs
  • Debug App Engine programs
  • Use Restart in App Engine programs

Using the Do Select Action

  • Use Do Select
  • Use Restartable

Incorporating Conditional Processing

  • Define Do actions and explain Do action program flow
  • Create conditional statements using SQL
  • Use Application Engine libraries

Using PeopleCode with Application Engine

  • Insert PeopleCode into an Application Engine program
  • Use dynamic calls

Using Set Processing

  • Modify a program to use set processing

Using Temporary Tables

  • Implement parallel processing
  • Explain run time allocation

Executing Application Engine Programs

  • Configure a push button to execute an App Engine program
  • Execute an Application Engine program with a command script

Creating Process Definitions for Application Engine

  • Configure Process Scheduler to run Application Engine processes


  • Create and implement PSDAEMON programs

Measuring Application Engine Performance

  • Trace Application Engine programs

Tuning Application Engine Programs

  • Performance tune Application Engine programs

Integration Tools

Introducing PeopleSoft Integration Broker Architecture

  • Describe the components of the PeopleSoft Integration Gateway

Configuring PeopleSoft Integration Broker

  • Configure PeopleSoft Integration Broker
  • Create and configure nodes

Creating Messages

  • Define service configuration
  • Create rowset and non-rowset based messages
  • Use message parts

Creating Service Operations

  • Add and secure service operations
  • Create and configure queues
  • Add routings

Sending and Receiving Service Operations

  • Publish Service Operations using rowsets
  • Create Handlers for asynchronous service operations
  • Create handlers for synchronous service operations
  • Add handlers

Monitoring Service Operations

  • Monitor asynchronous services
  • Monitor synchronous services
  • Administer service operations
  • Monitor service operation performance and archive monitor data

Using Service Utilities

  • Administer services
  • Use the Handler Tester

Using the Oracle XSL Mapper

  • Install and configure JDeveloper
  • Create an application engine transform program
  • Test transform programs
  • Version and logically transform service operations

Applying Translations and Filtering

  • Create code sets for data translation
  • Write a transformation program for data translation

Testing Connector and Messages Using Send Master

  • Use Sendmaster to test service operation

Creating and Testing Component Interfaces

  • Describe the elements of a component interface definition
  • Create component interfaces
  • Set component interface security and test

Implementing Component Interfaces

  • Add component interface PeopleCode to an application

Working with Component Interface Collections

  • Write PeopleCode for component interface collections

Enabling Component Interfaces as Services

  • Use component interfaces as web services

Providing and Consuming Web Services

  • Provide web services
  • Consume web services
  • Secure web services

Using the Excel to Component Interface Utility

  • Create an application using Excel to Component Interface Utility

Importing Data into the PeopleSoft System Using Flat Files

  • Create file layout definitions
  • Import data using file layouts

Writing Data to Flat Files

  • Create application engine programs to export data to flat files
  • Create multilevel file layouts including segments



Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.



 E-mail this page  Printer View