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 OCTOBER 25, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms