Customer Merge Error: Fails With "ERROR: AR.AR_CMGT_ACCOUNT_MERGE.TRX_SUMMARY_ACCOUNT_MERGE Updating table AR_TRX_SUMMARY"
(Doc ID 303729.1)
Last updated on OCTOBER 13, 2022
Applies to:Oracle Trading Community - Version 11.5.9 and later
Oracle Receivables - Version 11.5.9 and later
Information in this document applies to any platform.
Run customer merge for some customer and it fails.
The following error appears in the log file:
MSG-00001: ARP_CMERGE_MASTER.merge_crm_products : User-Defined Exception
ARP_CMERGE_MASTER.merge_crm_products : User-Defined Exception
MSG-00100: merge_products errored out
The Customer Merge Execution Report is showing the merge status as "Failed" with the following error:
Updating table AR_TRX_SUMMARY
Customer Merge runs successfully for other customers.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!