My Oracle Support Banner

PV_REQ_LN_XREF Row(s) Not Created For DirectConnect Requisition (Doc ID 2484256.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

PV_REQ_LN_XREF row(s) not created for DirectConnect requisition

DirectConnect requisitions are randomly missing rows in the table PS_PV_REQ_LN_XREF which is needed when creating the PO. Usually it is a line or two, occasionally the entire requisition is missing. It then causes missing data to be sent to the vendor.

Steps to reproduce the issue:

1) Navigate to eProcurement > Requisition
2) Clcik on a Direct connect link under Web
3) Add a item from the punchout supplier and click Checkout
4) Get back to eProcurement Review and Submit page.
5) Click on Save for later

Changes

 

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
Changes
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.