Getting Error "EGO_ITEM_PUB.PROCESS_ITEMS: Unique Constraint (INV.MTL_PENDING_ITEM_STATUS_U1) Violated" While Calling API to Create Item Catalog
(Doc ID 2787626.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Inventory Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Other Inventory Issues
Actual Behavior
While trying to create item catalog element value using the API EGO_ITEM_PUB.PROCESS_ITEMS, getting following error.
Error
EGO_INV_ITEM_CATALOG_PVT"."Change_Item_Lifecycle" "ORA-00001: unique constraint (INV.MTL_PENDING_ITEM_STATUS_U1) violated".
Steps
- Write a PL/SQL code to call API EGO_ITEM_PUB.PROCESS_ITEMS
- Pass necessary value to the code.
- Call PL/SQL block and see the error in API output.
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 |