My Oracle Support Banner

Planning ODS Load - ORA-00001 Unique Constraint (MSC.ITEM_CATEGORIES_U1) violated (Doc ID 752491.1)

Last updated on NOVEMBER 15, 2018

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On an 11.5.10.2 instance with dual language installation (English and Hebrew):


When running 'Planning Data Collections', the 'Planning ODS Load' completes with the following error:

ORA-00001: unique constraint (MSC.ITEM_CATEGORIES_U1_AS) violated


Using <Note 333758.1>, one has found that MRP_AP_ITEM_CATEGORIES_V view contains duplicate rows.  One of the tables that the above source view is based on is MTL_ITEM_CATEGORIES_TL where for each item there are 'US' and 'IW' records.
Currently, the source view is duplicated for each item due to both languages.

Stepse:
Run data collections with an older view definition of the MRP_AP_ITEM_CATEGORIES_V view, that does not select item categories for a specific language.

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
Cause
Solution

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