ADpatch Failure While Applying EBS R12.1.1 MP - Cannot Drop Index BEN_ACTN_TYP_TL_PK (Doc ID 1219494.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Advanced Benefits - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 version, Installation Issues

ADPATCH failed while applying EBS R12.1.1 Maintenance Pack (patch 7303030) to a R12.0.4 instance. The following is from the adworker log:

The index BEN_ACTN_TYP_TL_PK on table BEN_ACTN_TYP_TL
has the wrong columns or the columns in the wrong order.
Index BEN_ACTN_TYP_TL_PK currently in the database
is a unique index on the columns:
LANGUAGE, ACTN_TYP_ID of the table BEN_ACTN_TYP_TL
Replace the index with the statements:
Start time for statement below is: Tue Jul 06 2010 12:47:03
DROP INDEX BEN.BEN_ACTN_TYP_TL_PK

AD Worker error:
The following ORACLE error:
ORA-02429: cannot drop index used for enforcement of unique/primary key occurred while executing the SQL statement:
DROP INDEX BEN.BEN_ACTN_TYP_TL_PK

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above.

 

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