My Oracle Support Banner

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 JANUARY 31, 2018

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

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.