My Oracle Support Banner

Error "Ora-02291: Integrity Constraint (RMS.SHS_UAT_FK) Violated - Parent Key Not Found" While Receiving. (Doc ID 1338106.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Integration Bus - Version 13.1.1.2 and later
Oracle Retail Merchandising System - Version 13.1 and later
Oracle Retail Store Inventory Management - Version 13.1 and later
Information in this document applies to any platform.
Checked for relevance on 15-Aug-2014
Checked for relevance on 29-Aug-2017

Symptoms

When attempting to process the Receipts from Store Inventory Management (SIM) to Retail Merchandising system (RMS) through Retail Integration Bus (RIB), the following error occurs in RIB and the messages are failing in RIB-RMS error Hospital.

Error:

Error ORA-02291: integrity constraint (RMS.SHS_UAT_FK) violated - parent key not found returned by program unit STOCK_ORDER_RECONCILE_SQL.FROM_LOC_ADJUST.

 

Cause

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
Symptoms
Cause
Solution


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