My Oracle Support Banner

Error ORA-02291 On Adding A Location To The Children (Doc ID 2716786.1)

Last updated on OCTOBER 19, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.


Adding location to a Children by selecting one of the  “Primary Supplier Site” not associated with the Parent the following error occurs.
"Error ORA-02291: integrity constraint (RMS.ITL_ISP_FK) violated - parent key not found returned by program unit NEW_ITEM_LOC_SQL.PERSIST."

Steps To Recreate:
1. Create or access an existing Children.
2. Add if required one “Supplier Site” not associated with the Parent.
3. Try to add a new Location to the Children selecting the “Supplier Site” not associated with the Parent in the “Primary Supplier Site” field.
4. Note the above error.


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.