Error ORA-02291 While Creating A New User Defined Attributes

(Doc ID 2361320.1)

Last updated on FEBRUARY 21, 2018

Applies to:

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

Symptoms

Getting below error while uploading a new User Defined Attributes(UDA).

ORA-02291:integrity constraint(RMS01.UDV_UDA_FK) volated -parent key not found returned by program unit CORESVC_UDA.EXEC_UDA_VALUES_INS.

Steps to Reproduce:

1. Go to Foundation Data>Data Loading>Download
2. Download and Save.
3. Open the excel file.
4. Delete two records in the UDA sheet and one record with the same UDA number deleted in UDA sheet in the UDA_VALUE section.
5. Save the excel file.
6. Go to Foundation Data>Data Loading>Upload
7. Click Done
8. Go to Foundation Data>Data Loading>Review Status.
9. Note the above error.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms