Ods Load Worker Warning Ora-00001 (Msc.Item_categories_u1_11i) PROCEDURE=LOAD_CATEGORY (Doc ID 362397.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
EXECUTABLE:MSCPDCW - Planning ODS Load Worker

Symptoms

When running data collections, the MSCPDCW module: Planning ODS Load Worker completes with a warning:

Error in PROCEDURE=LOAD_CATEGORY, TABLE=MSC_ITEM_CATEGORIES
ORA-00001: unique constraint (MSC.ITEM_CATEGORIES_U1_11I) violated
ORA-00001: unique constraint (MSC.ITEM_CATEGORIES_U1_11I) violated
ORA-00001: unique constraint (MSC.ITEM_CATEGORIES_U1_11I) violated

The last part of the unique index (ie _11I is the instance code and obviously can vary from instance to instance)

ERROR

Ora-00001: unique constraint (msc.item_categories_u1_11i) violated

 

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