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.




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