Upgrade Fails At Creating Index AR_GTA_TRX_HEADERS_U2
Last updated on APRIL 17, 2018
Applies to:Oracle Receivables - Version 12.2 and later
Information in this document applies to any platform.
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.
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
AD Worker error:
The index cannot be created as the table has duplicate keys.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms