Last updated on AUGUST 17, 2016
Applies to:Oracle Receivables - Version 11.5.0 to 220.127.116.11 [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
When attempting to run customer merge with the 'Delete After Merge' flag not enabled
the following error occurs.
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
The issue can be reproduced at will with the following steps:
1. Responsibility : AX Receivables
Navigation: Customer > Account Merge
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms