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 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
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
| Symptoms |
| Cause |
| Solution |
| References |