Execution of OKLRINV.odf, error, ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found was encountered (Doc ID 2188843.1)

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.

Symptoms

On : 12.2 version, Patch Application Issues

When running R12.2 upgrade driver to upgrade from R11i to R12, it fails with
the following:

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run upgrade driver patch 10124646

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms