PO_REQLOAD PROCESS Abended at Step PO_REQLOAD.COPYDIST.COPY
(Doc ID 2824947.1)
Last updated on MARCH 06, 2023
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
PO_REQLOAD Application Engine process fails because of uniqueness key violation in PO_REQLOAD.COPYDIST.COPY when populating table PS_RQLD_LDDST_T8 from PS_RQLD_LOAD1_T8.
Steps to reproduce the issue:
1. Select Max Load Lines=1 in Installation Options (Main Menu>Set Up Financials/Supply Chain>Install> On Installation Options page click on Purchasing>Requisition Loader Parameters>Select Max Load Lines=1)
2. Set the Requisition Loader defaults (per the screenshots attached to the KM) in Main Menu>Set Up Financials/Supply Chain>Product Related>Procurement Options>Purchasing>Requisition Loader Defaults.
3. On VP1 profile in “Procurement” tab, leave blank “Requester” field in Main Menu>Set Up Financials/Supply Chain> Common Definitions>User Preferences>Define User Preferences>Procurement tab.
4. Check you have data for PO_REQLOAD on US009 / GBR03. We need 4 lines on 2 BU (US009/GBR03) with REPLEN_STATUS = 1.
5. Run AE PO_REQLOAD on System source BIN for All Business Units. Process failed with the error below.
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 |