My Oracle Support Banner

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 JANUARY 03, 2023

Applies to:

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

Symptoms

PROBLEM
---------------
Getting error while applying below Patch to upgrade TCS functionality.
  32509728:R12.JAI.B
 
ERROR
-----------------------
Patch Log:
FAILED: file jain23.odf on worker 1 for product ja username JA.

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:
Unable to compare or correct tables or indexes or keys
because of the error above

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.

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!


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.