Planning ODS Load - ORA-00001 Unique Constraint (MSC.ITEM_CATEGORIES_U1) violated
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 184.108.40.206 to 220.127.116.11 [Release 11.5]
Information in this document applies to any platform.
On an 18.104.22.168 instance with dual language installation (English and Hebrew):
When running 'Planning Data Collections', the 'Planning ODS Load' completes with the following error:
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.
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