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 SEPTEMBER 28, 2017

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

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