My Oracle Support Banner

Error ORA-02291 While Creating A New User Defined Attributes (Doc ID 2361320.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


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.




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.