My Oracle Support Banner

The PO Upgrade App engine(UPG_PO) is Updating Incorrect Values(LN_TYPE) for the Punchout in the REQ_LINE record (Doc ID 2312013.1)

Last updated on FEBRUARY 11, 2019

Applies to:

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

Symptoms

Issue:-The PO upgrade app engine is updating incorrect values(LN_TYPE) for the Punchout in the REQ_LINE record


Details of the Issue in UPG_PO App engine:
In 9.2, when we create a new transaction with a Direct Connect Supplier and Punchout method, the 'DCPO' LN_TYPE is updated in the REQ_LINE table.
The same is not true for the the UPG_PO engine SQL section where it is checking for the condition

-AND XREF.MERCHANTID = SP.PV_MS_SUP_MPID

Which will always be false as there is no provision to add PV_MS_SUP_MPID field from the front end for the DC linked suppliers



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
References


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