My Oracle Support Banner

Error Removing UDAs From Template (Doc ID 2697099.1)

Last updated on AUGUST 07, 2020

Applies to:

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

Symptoms


When a UDA record is deleted from the User Defined Attributes template on the Data Loading Status screen it appears that the upload was successfully processed but with errors, it is checked in detail and the message appears that the record was not found on the UDA_Defaults tab, however in the database the records of the three tabs were deleted, even in the UDA_ITEM_DEFAULTS table.

ERROR
-----------------------
UDA_defaults, UDA,UDA_value cannot find records error

 

Steps to reproduce:

 

  1. Click on Tasks>> Click on Foundation Data >>Click on Data Loading>> Click on Download.
  2. Display the Template Type combo and select Items.
  3. Display the Template combo and select User Defined Attributes.
  4. Click on the Download button.
  5. Save the Template User Defined Attributes and prepare an Excel record of the UDAs, UDA_Values and UDA_Defaults tabs by changing the value of the Action column to Delete.
  6. Click on Tasks >> Click on Foundation Data>>Click on Data Loading>>Click on Upload.
  7. Display the Template Type combo and select Items.
  8. Expand the Template combo and select User Defined Attributes.
  9. Click on the Browse button.
  10. Select the file and click Open (from step 5).
  11. Click on the Upload button. Checked in detail and the message appears that the record was not found on the UDA_Defaults tab.


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.