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.


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.


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