My Oracle Support Banner

Worker "arhz.odf" failed during EBS Upgrade from 12.1 to 12.2 (Doc ID 2704843.1)

Last updated on AUGUST 31, 2020

Applies to:

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

Symptoms

Worker "arhz.odf" is failing during EBS upgrade. Error is shown in adworker log as below:

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

Start time for statement below is: XXXXXXXXXXXX

CREATE UNIQUE INDEX AR."HZ_CUST_ACCT_SITES_U2" ON AR.HZ_CUST_ACCT_SITES_ALL
(ORIG_SYSTEM_REFERENCE, ORG_ID) LOGGING STORAGE (FREELIST GROUPS 4
FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE

Statement executed.

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

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!


In this Document
Symptoms
Cause
Solution
References


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