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.

Symptoms

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.

Changes

 

Cause

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