ORA-02291: Integrity Constraint (GMI.IC_LOTS_MST_IC_ITEM_MST_B_FK) Violated When Saving Item in Process Manufacturing Inventory
Last updated on JULY 03, 2017
Applies to:Oracle Process Manufacturing Inventory - Version 11.5.10 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
When saving a new item in OPM inventory > Setup > Item Master receive error:
When running a SQL*Plus script to insert a 'dummy' into IC_ITEM_MST_B for diagnostic purposes, receive the following errors:
(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'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms