My Oracle Support Banner

ORA-02291: Integrity Constraint (GMI.IC_LOTS_MST_IC_ITEM_MST_B_FK) Violated When Saving Item in Process Manufacturing Inventory (Doc ID 302368.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Process Manufacturing Inventory - Version 11.5.10 to [Release 11.5]
Information in this document applies to any platform.


When saving a new item in OPM inventory > Setup > Item Master receive error:

ORA-02291: integrity constraint (GMI.IC_LOTS_MST_IC_ITEM_MST_B_FK) violated - parent key not found

 When running a SQL*Plus script to insert a 'dummy' into IC_ITEM_MST_B for diagnostic purposes, receive the following errors:

ORA-20001: APP-FND-01934: ORA-00001: unique constraint
(ENI.ENI_OLTP_ITEM_STAR_U3) violated in Package ENI_ITEMS_STAR_PKG Procedure
ORA-06512: at "APPS.APP_EXCEPTION", line 70
ORA-06512: at "APPS.INV_ITEM_PVT", line 2906
ORA-06512: at "APPS.GMF_PR_ITEM_INS", line 303
ORA-06512: at "APPS.GMF_IC_ITEM_MST_BIUR_TG", line 706
ORA-04088: error during execution of trigger 'APPS.GMF_IC_ITEM_MST_BIUR_TG'


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

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