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.
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
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.:
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