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 JULY 12, 2017

Applies to:

Oracle Trading Community - Version 11.5.10.2 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms