Think time Error (2,148) Accessing Requisition Page with 'Run Query Statistics' Turned ON (Doc ID 2053252.1)

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.

Goal

 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.

Solution

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 hundreds of Community platforms