Patch Application Fails Running FndXdfCmp To Create An Index With Error: A Different Index With Same Column Name Exists (Doc ID 1514897.1)

Last updated on JULY 28, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

Patch Application fails running FndXdfCmp to create an index with the following error:

CREATE INDEX "XLA"."XLA_AE_LINES_N5" ON "XLA"."XLA_AE_LINES" ("CODE_COMBINATION_ID", "LEDGER_ID", "ACCOUNTING_DATE")
 PCTFREE 10 INITRANS 11 MAXTRANS 255
 STORAGE(
 BUFFER_POOL DEFAULT) LOCAL
( PARTITION AP TABLESPACE APPS_TS_TX_IDX ,
PARTITION AR TABLESPACE APPS_TS_TX_IDX ,
PARTITION CE TABLESPACE APPS_TS_TX_IDX ,
PARTITION CST TABLESPACE APPS_TS_TX_IDX ,
PARTITION PO TABLESPACE APPS_TS_TX_IDX ,
PARTITION PSB TABLESPACE APPS_TS_TX_IDX ) PARALLEL NOLOGGING
ALTER INDEX XLA.XLA_AE_LINES_N5 NOPARALLEL LOGGING

A Different index with same column name exists

AD Worker error:
The utility FndXdfCmp returned error for the above task.

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