R12 - Party Merge Fails in Procedure HZ_DQM_SYNC.STAGE_PARTY_SITE_MERGE for entity HZ_STAGED_PARTY_SITES (Doc ID 951311.1)

Last updated on MAY 31, 2019

Applies to:

Symptoms

Submit a party merge (ARHPMERGE module) for Party Number 598012 to Party Number 598436 and the request errors out with the following error in the log file:

**** Error ****
Error: Merge failed in procedure HZ_DQM_SYNC.STAGE_PARTY_SITE_MERGE for entity HZ_STAGED_PARTY_SITES
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-10602: failed to queue DML change to column CONCAT_COL for primary key AACuVEAB4AAAHuUAAF
DRG-50857: oracle error in drexrdml
ORA-01031: insufficient privileges

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 656
.... 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 : 10-06-09 14:58:25
-----------


The error is not reproduced at will and only happens to these two parties.

Changes

Cause

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