My Oracle Support Banner

Cannot Copy Requisition When Requester Different from Target Requester (Doc ID 2481503.1)

Last updated on FEBRUARY 04, 2019

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

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.

Steps
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

Error:
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.
 

Solution

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
Goal
Solution
References


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