PO_REQLOAD Requisition Loader Process Fails With ORA-00001: Unique Constraint (SYSADM.PS_REQ_VC_IN1_T) error at Step PO_REQLOAD.RL8000.CRVCIN1 (SQL) When Using a Range of Business Unites
(Doc ID 3043705.1)
Last updated on OCTOBER 01, 2024
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 Requisition Loader process fails with unique constraint error at Step PO_REQLOAD.RL8000.CRVCIN1 (SQL) when a range a business units is used.
Error:
ORA-00001: unique constraint (SYSADM.PS_REQ_VC_IN1_T) violated
ORA-00001: unique constraint (SYSADM.PS_REQ_VC_IN1_T) violated
Steps to reproduce the issue:
1. Navigate to: Purchasing > Requisitions > Load Requisitions;
2. Run the process for a range of business Unites;
3. Process goes to no success.
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 |