R12.2 Upgrade Failed With AD Worker Error "The Index Cannot Be Created As The Table Has Duplicate Keys." (Doc ID 2869517.1)

Last updated on OCTOBER 23, 2023

Applies to:

Oracle Financials for India - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

R12.2 upgrade failed with AD worker error "The index cannot be created as the table has duplicate keys."

CREATE UNIQUE INDEX JA."JAI_INV_ITM_TAXCTG_DTLS_U1" ON
JA.JAI_INV_ITM_TAXCTG_DTLS (INVENTORY_ITEM_ID, TAX_CATEGORY_LIST) 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.

Use the following SQL statement to identify the duplicate keys:

SELECT INVENTORY_ITEM_ID, TAX_CATEGORY_LIST, count(*)
  FROM JA.JAI_INV_ITM_TAXCTG_DTLS
GROUP BY INVENTORY_ITEM_ID, TAX_CATEGORY_LIST
  HAVING count(*)>1

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

The issue can be reproduced at will with the following steps:
1. Upgrading to EBS R12.2.
2. Apply the R12.2 upgrade driver patch 10124646.

Changes

Apply the R12.2 upgrade driver patch 10124646.

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

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

R12.2 Upgrade Failed With AD Worker Error "The Index Cannot Be Created As The Table Has Duplicate Keys." (Doc ID 2869517.1)

Applies to:

Symptoms

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!