My Oracle Support Banner

Error ORA-02291: Integrity Constraint Using Xitem With Item/Supp/Country/Dimensions (Doc ID 1443902.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

When Item data is integrated to Oracle Retail Merchandising Support (RMS) via the XITEM subscription API, and when the item has multiple suppliers, each with dimensions, the data is not created in ORMS and the following error message is received:

"Error ORA-02291: integrity constraint (RMS13.ISD_ISC_FK) violated - parent key not found returned by program unit ITEM_SUPP_COUNTRY_SQL.INSERT_ISC_DIM. - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_XITEM.CONSUME(?,?,?,?)}: [E] \"



Steps to Re-create:

1. Subscribe the XITEM which is having multiple suppliers with dimension data attached to it.
2. Notice the error message is displayed to the user:
Error ORA-02291: integrity constraint (RMS13.ISD_ISC_FK) violated - parent key not found returned by program unit ITEM_SUPP_COUNTRY_SQL.INSERT_ISC_DIM

Changes

 

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
Changes
Cause
Solution
References


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