My Oracle Support Banner

During 12.2.12 Upgrade, ADworker Failed With Error - 'The index cannot be created as the table has duplicate keys' (Doc ID 2996501.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Inventory Management - Version 12.2.12 and later
Information in this document applies to any platform.

Symptoms

During 12.2.12 upgrade, the driver patch (12.2.0 upgrade driver u10124646.drv) failed with below error

 ADworker log shows the below:


 CREATE UNIQUE INDEX INV."MTL_KANBAN_PULL_SEQUENCES_U2" ON
 INV.MTL_KANBAN_PULL_SEQUENCES (INVENTORY_ITEM_ID, ORGANIZATION_ID,
 KANBAN_PLAN_ID, SUBINVENTORY_NAME, LOCATOR_ID) LOGGING STORAGE (FREELIST
 GROUPS 4 FREELISTS 4 )  PCTFREE 50 INITRANS 11 MAXTRANS 255 COMPUTE
 STATISTICS   TABLESPACE APPS_TS_TX_IDX


The index cannot be created as the table has duplicate keys.


STEPS
-----------------------
Apply 12.2.0 upgrade driver u10124646.drv  patch.

ADworker fails with mentioned error
 

Changes

 Upgrade from 12.1.3 to 12.2.12

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
Changes
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.