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 JULY 03, 2017

Applies to:

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

Symptoms

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
INSERT_ITEMS_IN_STAR
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'

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