FORM Throws Think-time PeopleCode Error after Clicking "Preview Approval" Button
Last updated on MAY 28, 2018
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Forms throwing below error after adding the specific Userlist (Position related) when clicking on Preview Approval button but it is working after Submitting the Form
Think-time PeopleCode event (EvalDoModalPopup), but a SQL update has occurred in the commit interval.
EOFM_FL.Controller.FormController.OnExecute Name:FormApprWrk_PreviewPB_FieldChange PCPC:18583 Statement:329
Called from:EOFM_FORM_FL.GBL.FORM_APPR_WK.EOAW_PREVIEW.FieldChange Statement:1
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.
The issue can be reproduced at will with the following steps:
1. Go to Design Form tile->Edit form->Add approval user list as By Partial PosnSuprvisorID.
2.Click on Form Tile.Enter values in the fields and Click on the Preview Approval Button.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms