Patch fails Creating Index : The CREATE INDEX Statement Failed Because There is Another Index on the Same Columns

(Doc ID 1937386.1)

Last updated on MARCH 30, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

Attempting to apply <Patch 19512675>:R12.AR.B and receive the following error:

Error:
The table is missing the index AR_CASH_RECEIPTS_CE_N1 or index AR_CASH_RECEIPTS_CE_N1 exists on another table.
Create it with the statement:

Start time for statement below is: Mon Oct 20 2014 14:35:22

CREATE INDEX AR.AR_CASH_RECEIPTS_CE_N1 ON AR.AR_CASH_RECEIPTS_ALL
(REMIT_BANK_ACCT_USE_ID, ORG_ID, TYPE) LOGGING STORAGE (FREELIST GROUPS 4
FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
PARALLEL TABLESPACE APPS_TS_TX_IDX

Statement executed.

The CREATE INDEX statement above failed because there is another index on the same columns.
Looking for the existing index on the same columns...

AD Worker error:
Unable to find existing index on the same columns

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