E-UPG: How to resolve the "ORA-01452: cannot CREATE UNIQUE INDEX;duplicate keys found " during the Step 5-5-31 : Reviewing The Create Indexes Log in HCM 9.2 Upgrade (Doc ID 1565387.1)

Last updated on JULY 23, 2024

Applies to:

Goal

How to resolve the Unique Index constraints messages : "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found " found during the task "Task 5-5-31: Reviewing the Create Indexes Log" in HRMS 9.2 Application Upgrade ?

------------------------------------------------------------------------------------------------------

alltabs_crtidx.log shows the Unique Constraints as below:

CREATE UNIQUE  iNDEX PS_GP_ABSSS_V_XREF ON PS_GP_ABSSS_V_XREF
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P015
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


CREATE UNIQUE  iNDEX PS_HCDL_ADMIN_XREF ON PS_HCDL_ADMIN_XREF
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P015
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

same error for the below indexes

PS_HCDL_APPR_XREF(EOAWTHREAD_ID,EOAWPRCS_ID)
PS_HCDL_BATCH_XREF(EOAWTHREAD_ID,EOAWPRCS_ID)
PS_HCDL_RVK_XREF(EOAWTHREAD_ID,EOAWPRCS_ID)
PS_HCSC_AWE_TXNLOG(EOAWTHREAD_ID,EOAWPRCS_ID)
PS_JPM_SRCH_CFG(OBJECTOWNERID, JPM_SRCH_SUB_ID,JPM_SRCH_ID)
PS_JPM_SRCH_CFGLNG(OBJECTOWNERID,JPM_SRCH_SUB_ID,JPM_SRCH_ID,LANGUAGE_CD)
------------------------------------------------------------------------------------------------------

Solution

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