My Oracle Support Banner

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 FEBRUARY 15, 2019

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.
e.g.
Release 12.0.4 upgrade <Patch 6394500>
Refer to <Bug 7454955>: R12 UPGRADE: U6394500.DRV FAILS ON INVIREV.ODF ERRORING OUT WITH ORA-01452

Debug log file:




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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