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 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:
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