GST: Patch 32509728 Application Failed With Error "The index cannot be created as the table has duplicate keys" (Doc ID 2918242.1)

Last updated on MARCH 05, 2023

Applies to:

Symptoms

PROBLEM
---------------
Getting error while applying Patch 32509728:R12.JAI.B to upgrade TCS functionality.
 
ERROR
-----------------------
Patch Log:

AD Worker log:
CREATE UNIQUE INDEX JA.JAI_OM_WSH_LINE_TAXES_U1 ON JA.JAI_OM_WSH_LINE_TAXES

(DELIVERY_DETAIL_ID, ORDER_LINE_ID, TAX_ID) LOGGING STORAGE (FREELIST
GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE
STATISTICS TABLESPACE APPS_TS_TX_IDX

The index cannot be created as the table has duplicate keys.
Use the following SQL statement to identify the duplicate keys:

SELECT DELIVERY_DETAIL_ID, ORDER_LINE_ID, TAX_ID, count(*)
FROM JA.JAI_OM_WSH_LINE_TAXES
GROUP BY DELIVERY_DETAIL_ID, ORDER_LINE_ID, TAX_ID
HAVING count(*)>1

AD Worker error:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch 32509728:R12.JAI.B using adop command.
    $ adop phase=apply patches=32509728

2. Observe that the Patch application has failed.
3. Review the Patch Worker and AD Worker log and observe the error.

Cause

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