During Upgrade From 12.0.6 to 12.2 Get Error "ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found" Running arrcta.odf (Doc ID 2037994.1)

Last updated on MARCH 27, 2017

Applies to:

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

Symptoms

Upgrading from 12.0.6 to 12.2, the following error occurs when running arrcta.odf:


CREATE UNIQUE INDEX AR."RA_CUSTOMER_TRX_U3" ON AR.RA_CUSTOMER_TRX_ALL
(DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE) LOGGING STORAGE (FREELIST GROUPS 4
FREELISTS 4 )  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
PARALLEL  TABLESPACE APPS_TS_TX_IDX

AD Worker error:
The following ORACLE error:

ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


occurred while executing the SQL statement:

CREATE UNIQUE INDEX AR."RA_CUSTOMER_TRX_U3" ON AR.RA_CUSTOMER_TRX_ALL
(DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE) LOGGING STORAGE (FREELIST GROUPS 4
FREELISTS 4 )  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
PARALLEL  TABLESPACE APPS_TS_TX_IDX

AD Worker error:

Unable to compare or correct tables or indexes or keys because of the error above

Due to this issue, upgrade is stopped.

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