My Oracle Support Banner

During XITEM Creation SINGLE_UDA_EXISTS Error Showin If UDA Value Given Is Other Than The Value Present On UDA_ITEM_DEFAULTS (Doc ID 2774965.1)

Last updated on MAY 28, 2021

Applies to:

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

Symptoms

SINGLE_UDA_EXISTS error occurs during XITEM creation if any UDA value is given other than the value defined in the UDA_ITEM_DEFAULTS table.
 
Steps to reproduce:
1. Ensure the UDA_ITEM_DEFAULTS has a value set for a UDA (with SINGLE_VALUE_IND=Y)
2. Create an item using XITEM stub for this department and change the UDA_VALUE to another from what is mentioned in the UDA_ITEM_DEFAULTS
3. Notice the below Error during execution of the stub for XITEM

Status Code:E:
Actual:Error ORA-20001: There should only be one UDA for the item/UDA ID.UDA_ID:103,ITEM:101165035 returned by program unit CORESVC_ITEM.PROCESS_UIL.:
Error msg:Error ORA-20001: There should only be one UDA for the item/UDA ID.UDA_ID:103,ITEM:101165035 returned by program unit CORESVC_ITEM.PROCESS_UIL.:


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.