My Oracle Support Banner

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

Last updated on OCTOBER 13, 2022

Applies to:

Oracle Receivables - Version 11.5.0 and later
Oracle Trading Community - Version 11.5.3 and later
Information in this document applies to any platform.
Oracle Trading Community - Version: 11.5.3 and later.
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

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


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