Cannot Drop Index BEN_ACTN_TYP_TL_PK Error Applying R12.1.1 (7303030) (Doc ID 1451126.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Advanced Benefits - Version 12.1.1 and later
Information in this document applies to any platform.
Oracle Advanced Benefits - Version: 12.1 and later [Release: 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