RECLSDLY Batch Fails With Unique Constraint Error When Inserting Item UDA Data
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms