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

Last updated on JUNE 28, 2017

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

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