Running an OPM Data Collection results in 'Unique index violated - OPERATION_RESOURCES_U1_NFI' error for FOR Alternate Resource Defined.
(Doc ID 885495.1)
Last updated on DECEMBER 13, 2021
Applies to:
Oracle Process Manufacturing Process Planning - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
It was found that when an Alternate Resource is defined, the ODS Load Worker errors as below and the Data Collection completes normally if the Alternate Resource is not defined.
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
21-AUG 19:07:23 : WARNING
21-AUG 19:07:23 : Unique index violated - OPERATION_RESOURCES_U1_NFI
21-AUG 19:07:23 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
21-AUG 19:07:23 : WARNING
21-AUG 19:07:23 : Unique index violated - OPERATION_RESOURCES_U1_NFI
21-AUG 19:07:23 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Steps To Reproduce:
1. Define an Alternate Plant Resources.
2. Navigate to Advanced Supply Chain Planning > Collections > Collect From Oracle Systems > Standard Collections--> Launch the data collections.
3. See that planing ODS Load completes with warning with the said error.
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 |