Party Merge Error: Fails with ORA-29876: failed in the execution of the ODCIINDEXDELETE routine and DRG-10513: index HZ_STAGE_PARTY_SITES_T1 metadata is corrupt (Doc ID 1445954.1)

Last updated on OCTOBER 13, 2022

Applies to:

Symptoms

Running Party Merge fails with the following error messages in the log file:

**** Error ****
This unexpected SQL error occurred during the merge process :

ORA-29876: failed in the execution of the ODCIINDEXDELETE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexDelete
ORA-20000: Oracle Text error:
DRG-10607: index meta data is not ready yet for queuing DML
DRG-10513: index HZ_STAGE_PARTY_SITES_T1 metadata is corrupt
ORA-30576: ConText Option dictionary loading error
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 773
.... One or more of the Merges in the batch had errors.
.... Please check the log file
.... No changes from the batch have been applied
Concurrent Program Execution completed
End Time : 03-23-12 08:46:24

 
Steps to reproduce:

Responsibility: Trading Community Manager
Navigation: Data Quality management > Party Merge

1. Enter From and To Party
2. Submit the merge

Changes

Party Merge stops working after a few patches were applied which includes the Oracle Text <Patch 12960302>

Cause

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