Upgrade Fails At Creating Index AR_GTA_TRX_HEADERS_U2

(Doc ID 2380447.1)

Last updated on JULY 11, 2018

Applies to:

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

Symptoms

On : 12.2 version, Receivables Uptake of EBTAX

Upgrade fails at creating index AR_GTA_TRX_HEADERS_U2

This occurs when  running the 12.2 upgrade driver and the patch fails at creating index AR_GTA_TRX_HEADERS_U2.
 

ERROR
-----------------------

CREATE UNIQUE INDEX AR."AR_GTA_TRX_HEADERS_U2" ON AR.AR_GTA_TRX_HEADERS_ALL
(GTA_TRX_NUMBER, ORG_ID, SOURCE) LOGGING STORAGE (FREELIST GROUPS 4
FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE APPS_TS_TX_IDX

Statement executed.

AD Worker error:
The index cannot be created as the table has duplicate keys.



Changes

 

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