My Oracle Support Banner

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

Last updated on MARCH 22, 2021

Applies to:

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


On an 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.

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.


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

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