MSCPLD Loader Worker With Direct Load Option Errors With ORA-00001 MSC.MSC_ITEM_SOURCING_U1 Violated
(Doc ID 742310.1)
Last updated on JULY 05, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and laterInformation in this document applies to any platform.
EXECUTABLE:MSCPLD - Loader Worker With Direct Load Option
Symptoms
When attempting to run an ASCP plan the following error occurs in MSCPLD - Loader Worker With Direct Load Option:
Record 3945: Rejected - Error on table MSC.MSC_ITEM_SOURCING.
ORA-00001: unique constraint (MSC.MSC_ITEM_SOURCING_U1) violated
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table MSC.MSC_ITEM_SOURCING:
3944 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
ORA-00001: unique constraint (MSC.MSC_ITEM_SOURCING_U1) violated
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table MSC.MSC_ITEM_SOURCING:
3944 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Steps:
1. Run ASCP plan
2. MSCPLD errors with ORA-00001
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 |