My Oracle Support Banner

FORM Throws Think-time PeopleCode Error after Clicking "Preview Approval" Button (Doc ID 2404303.1)

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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.