My Oracle Support Banner

Unable To Create New Item In PIM getting error ORA-00001: unique constraint (EGO.EGO_MTL_SY_ITEMS_EXT_B_U1) violated (Doc ID 1679115.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
Executing - "EGO_USER_ATTRS_DATA_PVT"."Insert_Row" "ORA-00001: unique constraint (EGO.EGO_MTL_SY_ITEMS_EXT_B_U1) violated

Symptoms

When attempting to create Item in Product Information Management (PIM) following error occurs.

ERROR
Executing - "EGO_USER_ATTRS_DATA_PVT"."Insert_Row" "ORA-00001: unique constraint (EGO.EGO_MTL_SY_ITEMS_EXT_B_U1) violated

STEPS
1) Log in to Development Super User responsibility
2) Item Catalog > Create Production item
3) Choose an Item Catalog Category (ICC)
4) Click on Finish

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.