My Oracle Support Banner

Customer Merge (RAXMRG) Completes with Error - MSG-00001: Calling xla_third_party_merge_pub.third_party_merge (Doc ID 1944012.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


Attempting to run Customer Merge (RAXMRG) and it completes in error:

From the Log File:

MSG-00001: Calling xla_third_party_merge_pub.third_party_merge  04-NOV-2014
MSG-00001: p_original_third_party_id = 64045  04-NOV-2014 11:27:55
MSG-00001: p_original_site_id = 388816  04-NOV-2014 11:27:55
MSG-00001: p_new_third_party_id = 64043  04-NOV-2014 11:27:55
MSG-00001: p_new_site_id = 388812  04-NOV-2014 11:27:55
MSG-00001: x_retcode = E  04-NOV-2014 11:27:55
MSG-00001: Others Error in insert_full_merge_event User-Defined Exception
04-NOV-2014 11:27:55
x_retcode = E
Others Error in insert_full_merge_event User-Defined Exception  04-NOV-2014
MSG-00100: merge_products errored out
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()+04-NOV-2014 11:27:55
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()-04-NOV-2014 11:27:55

FND debug shows following issue:

xla_third_party_merge.third_party_merge: The value '' is not a valid value
for the parameter p_third_party_merge_date.
x_request_id = , x_event_ids.COUNT = 0
EXIT with ERROR - xla_third_party_merge_pub.third_party_merge


To view full details, 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 a vibrant support community of peers and Oracle experts.