Upgrade - invirev.odf Fails With ORA-01452 Cannot CREATE UNIQUE INDEX duplicate keys found MTL_ITEM_REVISIONS_TL_U2

(Doc ID 342557.1)

Last updated on MARCH 12, 2017

Applies to:

Oracle Inventory Management - Version 11.5.9 and later
Information in this document applies to any platform.
This problem can occur on any platform.
invirev.odf


Symptoms

Failure on invirev.odf when applying 

Patch 3046000 - 11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2
or
Patch 3480000 - ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK
or any other upgrade from an 11.5.9 release to 11.5.10.x or R12.

Debug log file:




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