My Oracle Support Banner

Think-time Error During Copy Requisitions With Query Statistics Enabled (Doc ID 1528499.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9 and later
Information in this document applies to any platform.

Symptoms

Receiving the following error when copying and ePro requisition which has a different Requester than the user logged in and Catalog Security is enabled and Run Query Statistics is enabled in Query Administration:

Invalid message while SQL transaction in process: The source requester (AMA2) is different from the target requester (VP1), copy? (10150,186) (2,178) FUNCLIB_PM.COPY_REQ.FieldFormula Name:copy_hdr PCPC:975 Statement:9
Called from:FUNCLIB_PM.COPY_REQ.FieldFormula Name:COPY_REQ Statement:698
Called from:PV_REQ_FORM.Activate Statement:245

A PeopleCode program tried to issue the indicated message while an SQL cursor is open. The message is invalid because it requires user input.

Review the PeopleCode and either move the message to a place where it will be issued during user "think-time", or change the "style" so no choice is required.

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
Symptoms
Cause
Solution


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