ItemDel Message Failed in RWMS With ORA-02292: Integrity Constraint ISCA_ISC_FK (Doc ID 2902261.1)

Last updated on SEPTEMBER 02, 2024

Applies to:

Symptoms

The messages of ItemDel get stuck in the RIB MESSAGE with the description "ORA-02292: integrity constraint (RWMS.ISCA_ISC_FK) violated - child record found"

These errors happen because when an Item is deleted in the table ITEM_MASTER, at the RMS, its sent an ItemDel to the others systems to delete the item in all tables.
In the case of WMS, the item cannot be deleted in the table ITEM_SUPP_COUNTRY, because still exists in the table ITEM_SUPP_COUNTRY_AI, which is a Foreign Key.

To reproduce the error, you have to follow the next steps:

1)Create an Item in RMS;
2)In the WMS, insert the item in the table ITEM_SUPP_COUNTRY_AI;
3)Delete Item in RMS;
4)Verify if there is a message of a ItemDel stuck in the RIB_MESSAGE of WMS.

The WMS version we have is 15.0.0.0, as you can see at the attached files.

ERROR
-----------------------
ORA-02292: integrity constraint (RWMS.ISCA_ISC_FK) violated - child record found




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1)Create an Item in RMS;
2)In the WMS, insert the item in the table ITEM_SUPP_COUNTRY_AI;
3)Delete Item in RMS;
4)Verify if there is a message of a ItemDel stuck in the RIB_MESSAGE of WMS.

Cause

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