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 220.127.116.11 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
On an 22.214.171.124 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.
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