When Running Collections for OPM, the Planning ODS Load Worker is Erroring With "Unique index violated - "OPERATION_RESOURCES_U1_PRD"" in the Log File
(Doc ID 2878293.1)
Last updated on JULY 11, 2022
Applies to:Oracle Process Manufacturing Process Planning - Version 12.2.10 and later
Information in this document applies to any platform.
When running Collections for OPM, the Planning ODS Load Worker is ending in error, with the following message in the log file:
Unique index violated - "OPERATION_RESOURCES_U1_PRD"
ORA-12801: error signaled in parallel query server P001
1. Run Collections (under responsibility Advanced Planning and Scheduling (Process Operations), OPM Supply Chain Planner, or OPM Material Planner, go to Collections > Oracle Systems > Standard Collection).
2. When Collections completes, check the Planning ODS Load Worker log (View > Requests > Find).
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