My Oracle Support Banner

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

Last updated on NOVEMBER 16, 2020

Applies to:

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

Symptoms

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.

 

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.