Cannot Copy Requisition When Query Statistics Enabled Due to Error: Invalid message while SQL transaction in process. The source requester (XXXXX) is different from the traget requester(YYYY).copy?(10150,186)(2,178)
(Doc ID 2481503.1)
Last updated on MARCH 05, 2020
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Qn1:What is your recommendation on Run Query Statistics? should it be deselected? what situations it should be selected?
Qn2:With Run Query Statistics ON
Cannot copy Requisition (from Manager Requisitions page ) when Requester is different from Target Requester.
1) Log in as User
2) Navigate to eProcurement > Manage Requisition search for Requisitions
3) select to copy Requisition click go, message appears as below
Invalid message while SQL transaction in process. The source requester () is different from the traget requester(POLURUR).copy?(10150,186)(2,178)
FUNCLIB_PM.COPY_REQ.FieldFormula Name:copy_hdr PCP:33567 Statement:521
Called from: FUNCLIB_PM.COPY_REQ.FieldFormula Name:COPY_REQ Statement:1332
Called from:PV_REQ_CHEKCOUT.Activate Statement:727
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.
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