My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.