My Oracle Support Banner

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:

Oracle Trading Community - Version 12.0.3 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Party Merge - ARHPMERGE module

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

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.