Last updated on APRIL 02, 2017
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Think time Error (2,148) Accessing Requisition Page with 'Run Query Statistics' Turned ON
Setup to Reproduce the Issue:
1) Have Catalog Security turned on. When catalog security is turned on queries are being used.
2) have Land on Settings page enabled in eProcurement
Steps to Reproduce the Issue:
1) Turn on "Run Query Statistics".
2) Click eProcruement--> Requisition users are receiving the following Peoplecode error.
Think-time PeopleCode event (EvalDoModal), but a SQL update has occurred in the commit interval. (2,148) PV_TREE_WRK.TREECTLEVENT.FieldFormula Name:LandOnSettingPg PCPC:88423 Statement:1550
Called from:PV_REQ_CATBROWSE.Activate Statement:26
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.
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