RAXMRG - AX Customer Merge Concurrent Request Erroring Out (Doc ID 361190.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Receivables - Version 11.5.0 to 11.5.10.3 [Release 11.5.0 to 11.5.10]
Oracle Trading Community - Version 11.5.3 to 12.1.0 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for Relevance 24-Jan-2013***
Oracle Trading Community - Version: 11.5.3 to 12.1
This problem can occur on any platform.
REPORT:RAXMRG.RDF - Customer Merge

Symptoms

When attempting to run customer merge with the 'Delete After Merge' flag not enabled
the following error occurs.

ERROR
MSG-00001: Locking table AX_EVENTS 07-MAR-2006 06:03:36
MSG-00001: Locking table AX_BALANCES 07-MAR-2006 06:03:36
MSG-00001: Locking table AX_EVENTS 07-MAR-2006 06:03:37
MSG-00001: Locking table AX_BALANCES 07-MAR-2006 06:03:37
MSG-00100: merge_products errored out
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()+07-MAR-2006 06:03:37
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()-07-MAR-2006 06:03:37
AX.AX_SC_MERGE_PKG.MergeTCA


STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility : AX Receivables

Navigation: Customer > Account Merge
choose:
From Type = Person
From Number = 2120
Delete after Merge = No
To Type = Person
To Number = 13867
Create Same Site = No
Save and Merge
Conurrent Request runs in error.

Note: Problem also occurs when they run customer merge for Organizations

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