RECLSDLY Batch Fails With Unique Constraint Error When Inserting Item UDA Data
(Doc ID 2278114.1)
Last updated on JUNE 22, 2017
Applies to:Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.
RECLSDLY [Item Reclassification] batch fails with below error for any items having data in UDA_ITEM_LOV and also having same UDA_ITEM_DEFAULTS defined for both old and new dept/class/subclass.
Steps to Reproduce:
1. Select an item for reclassification.
2. Make sure there are no open transactions for the item.
3. Make sure UDA_ITEM_DEFAULTS data is present for both from dept/class/subclass and to dept/class/subclass and is same.
4. Run the reclassification batches and note the issue.
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