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 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:

Reading objects from ODF file
Reading table MTL_ITEM_REVISIONS_B ...
Reading table MTL_ITEM_REVISIONS_TL ...
Reading table MTL_ITEM_REVISIONS_INTERFACE ...
*** Reading objects from INV schema
Reading table MTL_ITEM_REVISIONS_B from INV schema ...
Reading table MTL_ITEM_REVISIONS_TL from INV schema ...
Reading table MTL_ITEM_REVISIONS_INTERFACE from INV schema ...
===== Index MTL_ITEM_REVISIONS_B_N1 all columns match.
===== Index MTL_ITEM_REVISIONS_B_U1 all columns match.
===== Index MTL_ITEM_REVISIONS_B_U2 all columns match.
===== Index MTL_ITEM_REVISIONS_B_U3 all columns match.
===== Index MTL_ITEM_REVISIONS_TL_U1 all columns match.
*******************************************************
The table is missing the index MTL_ITEM_REVISIONS_TL_U2
or index MTL_ITEM_REVISIONS_TL_U2 exists on another table.
Create it with the statement:
 
Start time for statement below is: Fri Oct 28 2005 21:28:55

CREATE UNIQUE INDEX INV.MTL_ITEM_REVISIONS_TL_U2 ON
INV.MTL_ITEM_REVISIONS_TL (REVISION_ID, LANGUAGE) LOGGING  PCTFREE 10
INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE
APPS_TS_TX_IDX

AD Worker error:
The following ORACLE error:

ORA-12801: error signaled in parallel query server P002
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
 
occurred while executing the SQL statement:

CREATE UNIQUE INDEX INV.MTL_ITEM_REVISIONS_TL_U2 ON
INV.MTL_ITEM_REVISIONS_TL (REVISION_ID, LANGUAGE) LOGGING  PCTFREE 10
INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS PARALLEL TABLESPACE
APPS_TS_TX_IDX




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
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.