Execution of OKLRINV.odf, error, ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found was encountered
Last updated on SEPTEMBER 30, 2016
Applies to:Oracle Lease and Finance Management - Version 12.2 and later
Information in this document applies to any platform.
On : 12.2 version, Patch Application Issues
When running R12.2 upgrade driver to upgrade from R11i to R12, it fails with
FAILED: file OKLRINV.odf on worker 1.
AD Worker error:
The following ORACLE error:
ORA-12801: error signaled in parallel query server P005
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
The issue can be reproduced at will with the following steps:
1. Run upgrade driver patch 10124646
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms