My Oracle Support Banner

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 later
Information in this document applies to any platform.


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

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.