The Component PeopleCode also has additional events that the record level ones don't, like SavePreChange and SavePostChange. So once you get the hang who fires when you can get pretty granular control of the various events. There is actually a pretty good summary in the PeopleBooks here. Peoplecode Examples. PeopleCode that uses the Grid class to events that occur before the grid is built; the earliest event you can use is the Activate event. The Activate event is not associated with a specific row and record at the point of execution. This means you cannot use functions such as GetRecord, GetRow, and so on, which rely on context, without specifying. What do Integration Broker, Event Mapping, Tile Wizard, and AWE have in common? These are extensible PeopleSoft frameworks that invoke your code at runtime—Dynamic PeopleCode execution! How amazing is that? Every line of event PeopleCode you've ever written was declared in advance. PeopleCode events are initiated at particular times, in particular sequences, during the course of the Component Processor’s flow of execution. When an event is initiated, it triggers PeopleCode programs on specific objects. The following items have events that are part of the Component Processor flow.
Course Topics: Technology Overview Describing PeopleSoft Development Tools Describing PeopleSoft Enterprise Tools Describing Information Available in PeopleBooks Navigating PeopleSoft Applications Identifying Elements of the User Interface Navigating PeopleSoft Applications Entering and Modifying Data Navigating the Enterprise Portal Describing a PeopleSoft Enterprise Portal Describing PeopleSoft Portal Products and Solutions Describing PeopleSoft Architecture Describing PeopleSoft Databases Explaining Data Flow in PeopleSoft Pure Internet Architecture Validating Data Identifying Edit Types Viewing Effective-Dated Information Validating Data with PeopleCode Developing an Application Describing the Four Phases of Application Development Describing the PeopleSoft Design Methodology Identifying Features of PeopleSoft Application Designer Building PeopleSoft Definitions Automating Business Processes with PeopleSoft Workflow Describing the Features of PeopleSoft Workflow Identifying a Business Process Executing a PeopleSoft Application Engine Program Describing PeopleSoft Application Engine Features Describing PeopleSoft Application Engine Benefits Running an Application Engine Program Examining a PeopleSoft Application Engine Program Definition Integrating the Enterprise Describing the Features of PeopleSoft Integration Broker Exploring the Features of PeopleSoft Component Interfaces Exploring the Features of PeopleSoft Messaging Exploring the Features of File Layout Definitions Upgrading PeopleSoft Applications Describing an Upgrade Examining Upgrade Options Upgrading a Project Running Processes Using the Process Scheduler Examining the Features of PeopleSoft Process Scheduler Describing the Features of the Process Monitor Describing the Features of the Report Manager Monitoring the Performance of the Enterprise Describing Performance Monitor Features Describing the Benefits of the Performance Monitor Securing the Enterprise Describing the Features of PeopleSoft Security Examining Application Security Examining Other Types of Security
2) PeopleTools I Rel 8.48
Course Topics: Navigating PeopleSoft Applications Using Search Pages Identifying Definitions Entering and Modifying Data Finding Information Using PeopleBooks Explaining PeopleSoft Architecture Describing PeopleSoft Databases Explaining Data Transfer in PeopleSoft Pure Internet Architecture Identifying Requirements for the Development Environment Organizing Data Describing Relational Data Models Normalizing Data Reading Data Models Validating Data Describing Prompt Tables Using Effective Dating Comparing Validation Types Explaining Tableset Sharing Developing Applications by Using the Eight Steps Describing the PeopleSoft Application Development Process Describing the Application Designer Interface Organizing Definitions in a Project Designing the Application Planning the Application Determining Functional Specifications Determining Technical Specifications Describing the Training Application Defining Fields Discussing Fields in PeopleSoft Applications Identifying Field Definition Types and Properties Creating Field Definitions Assigning Translate Values Creating Record Definitions Discussing Fields in PeopleSoft Applications Identifying Field Definition Types and Properties Creating Field Definitions Assigning Translate Values Building SQL Tables Describing the Relationship Between Record Definitions and Application Data Tables Building Application Data Tables Viewing Table Indexes Creating Page Definitions Identifying Page Design Principles Identifying Page and Page Control Properties Adding Page Controls to a Page Creating Page Definitions Implementing Scroll Areas and Grids Defining Components Defining Component Properties Building New Components Registering Components Examining Menu Definitions Identifying PeopleSoft Security Basics Navigating the Portal Registry Registering a Component Testing an Application Creating and Analyzing Test Plans Troubleshooting Common Issues Editing the Registry Structure Discussing Content Organization in PeopleTools 8.4 Navigation Creating Folders Moving Folders or Content References to New Parent Folders Creating Menu Definitions Describing the Purpose of a Menu Locating a Component on a Menu Editing Menu Item Labels Analyzing the Impact of Design Changes Determining Relationships Among Definitions Synchronizing Record Definitions and Database Tables Incorporating Upgrades in the Development Strategy Searching Applications by Using the Verity Search Engine Describing and Performing a Verity Search Generating a Registry Search Collection Adding Keywords to a Search Collection Performing Data Audits Discussing Advantages and Disadvantages of Implementing Audits Implementing Field-Level Audits Implementing Record-Level Audits Importing and Exporting Projects Describing How Projects Transport Definitions Between Databases Exporting Projects
Course Topics: Developing Applications with PeopleTools Designing an Application Creating Data Structures Creating User Interfaces Testing Applications Applying Advanced Design Concepts Explaining the PeopleSoft Design Methodology Evaluating a Potential Change to an Application 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 Using PeopleCode to Manipulate Fields Using Objects in PeopleCode Defining Object-Oriented Terms Creating Custom Objects with Application Classes Describing Application Classes Organizing Application Classes Using Application Packages Editing Application Classes Calling Application Classes 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 Between 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
Savepostchange Peoplecode
4) PeopleCode Rel 8.44
Course Topics: 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 PeopleCode Search Events Identifying PeopleCode Component Build Events Identifying Field Action Events Identifying PeopleCode Row Action Events Identifying PeopleCode Save Action Events Describing Add Mode Processing Writing PeopleCode Programs Writing PeopleCode Statements Explaining Conditional Statements Explaining Looping Statements Understanding 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 into PeopleSoft Applications Explaining Variable Prompt Tables Explaining Arrays Using Built-In Functions Listing the Types of Built-In Functions Explaining Message Catalog Functions Describing All, None, and Prior Value Explaining String Functions Identifying Other Built-In Functions Explaining Reserved Words Writing PeopleCode Functions Writing External PeopleCode Functions Declaring a PeopleCode Function Calling PeopleCode Functions Writing Functions Using Parameters Writing Functions Using the Returns Argument Explaining the Component Buffer Determining Buffer Allocation Determining the Order of Execution of PeopleCode Programs Accessing Data in the Component Buffer Processing Rows Using Loops Using Fetch Value and Update Value Accessing Data with Multiple Occurs Levels Programming With Object-Oriented PeopleCode Defining Object-Oriented Terms Instantiating Objects Referencing Object Properties by Using Dot Notation Calling Object Methods by Using Dot Notation Explaining Passing by Reference Using Object-Oriented Methods and Properties Referencing Data in the Component Buffer Defining the Data Buffer Classes Instantiating the Buffer Access Classes Explaining Current Context Traversing the Data Buffer Using Shorthand Dot Notation Traversing the Data Buffer with Multiple Scroll Levels Creating Custom Objects with Application Classes Describing Application Classes Organizing Application Classes Using Application Packages Using the Application Class Editor Describing Application Class Structure Calling Application Classes Passing Parameters to Application Classes Using Data Buffer Methods Using the Sort Method Using the Select Method Using Flush Working With Standalone Rowsets Using More Buffer Methods Executing SQL in PeopleCode Writing SQL Exec Statements Creating SQL Definitions Using the SQL Class Executing SQL Using Record Objects Incorporating Meta-SQL in PeopleCode and SQL Searching PeopleCode for Potential SQL Injection
5) Application Engine Rel 8.48
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 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 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 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 Measuring Application Engine Performance Describing Traces Passing Trace Values to PSAE.EXE Interpreting Application Engine Trace Data Interpreting the PeopleTools Trace Describing Advanced Trace Options Tuning Application Engine Programs Describing the Process of Performance Tuning Identifying Application Level Tuning Opportunities Explaining the Performance Impact of PeopleCode Describing How Do Flow Control Affects Program Performance Explaining Database-Level Tuning Considerations
Last updated on NOVEMBER 15, 2019
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.
Getting the following error below after adding an escalation calendar to an approval workflow, no matter what the module is. Becasue of this issue, cannot save and use transactions in any of the modules where workflow was enabled and a calendar was added. ERROR: Think-time PeopleCode event (Warning), but a SQL update has occurred in the commit interval. (2,148) EOAW_CORE.ENGINE.AppInst.OnExecute Name:EscalSubmit PCPC:96367 Statement:1427 Called from:EOAW_CORE.NotificationEventHandler.OnExecute Name:ProcessNotifications Statement:1394 Called from:EOAW_CORE.ENGINE.AppInst.OnExecute Name:Launch Statement:21 Called from:EOAW_CORE.LaunchManager.OnExecute Name:DoSubmit Statement:33 Called from:FUNCLIB_REQ.REQ_STATUS.FieldFormula Name:KickoffAW Statement:16 Think-time PeopleCode events such as messages requiring a user response cannot be executed if a SQL update, insert, or delete has occurred in the commit interval. Examples of PeopleCode that invoke update type of SQL includes Process Scheduler, TriggerBusinessEvent, or MarkWorked. A unit of work cannot contain both think-time events and update type SQL. For this case, customer replication showing that the error happens in Payables module and in ePro module
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
Peoplecode Events Flow Chart
Symptoms
Peoplesoft Peoplecode Events Flow
Cause
Solution
Peoplecode Events Flow
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.