ECC Delivery Details Data Load Request Completed In Error: ORA-00001: unique constraint (INV.INV_ECC_OUT_TRACKER_NEW_U2) violated
(Doc ID 2930928.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.10 and laterOracle Inventory Management - Version 12.2.10 and later
Information in this document applies to any platform.
Symptoms
While running the Delivery Details Data Load request in Full Load for the ECC Shipping Dashboard, the load request completes with following error:
ERROR
---------
21:52:20.922 [pool-5-thread-3] ERROR 8.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code:There is Exception while applying load rule for dataset Delivery_Details for job xxxx There is Exception while applying load rule for dataset Delivery_Details for job xxxx exception details:
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (INV.INV_ECC_OUT_TRACKER_NEW_U2) violated
ORA-06512: at "APPS.INV_ECC_OUTBOUND_UTIL_PVT", line 42
ORA-06512: at "APPS.INV_ECC_OUTBOUND_UTIL_PVT", line 3707
ORA-06512: at line 1
The issue can be reproduced at will with the following steps:
1. Go to Inventory responsibility
2. Navigate to View menu -> Requests -> Submit a New Request.
3. Run the program 'ECC Run Data Load' to populate ECC Shipping Dashboard
4. Program will complete with above mentioned error in the log file
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 |