Requisition Loader (PO_REQLOAD) Process Not Populating Data In REQ_LINE, SHIP And DIST Tables (Doc ID 1989354.1)

Last updated on DECEMBER 09, 2016

Applies to:

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

Symptoms

Issue 1:  When we run Requisition Loader (PO_REQLOAD) process with Staging data such that some staging rows have Vendor ID and others dont have Vendor ID, then PO_REQLOAD Process does not populate data in REQ_LINE, REQ_LINE_SHIP and REQ_LN_DISTRIB for the requisitions which did not have Vendor ID.

Steps to reproduce the issue:

1) Go to Requisitions > Stagee for loading
2) Step 1 – Stage 3 row for Loading Requisition as follows –
Row 1 and 2 – Provide Supplier ID. No Item ID
Row 3– No Supplier ID. No Item ID
3) Run Req loader process.
4) The staged row without the Vendor ID gets inserted only in PS_REQ_HDR. No row inserted in PS_REQ_LINE , SHIP and DST. The row is marked with Load status Error in Req load request table

Issue 2:  When multiple rows are staged for the PO_REQLOAD process.  One row for an Adhoc item the other row for an Item ID. And the ReqLoad run control is set with Get Preferred Vendor = When not Specified", the staged row for the Adhoc item will end with a Process Status of ERROR.  Only the staged row for the Item ID will process successfully.

Steps to reproduce the issue:

  1. Enter Stage for Loading Data for an adhoc item (description only)
  2. Enter Stage for Loading Data for an Item ID
  3. Run the PO_REQLOAD process for System Source = BIN. Requesting Loader BU = US010
  4. Result: 1 requisition was created for the Item ID. The requisition data for the adhoc item is left in ERROR status (Stage for Loading page)



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