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 23, 2016

Applies to:

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

Symptoms

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
11:27:55
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
MSG-00001:
x_retcode = E
Others Error in insert_full_merge_event User-Defined Exception  04-NOV-2014
11:27:55
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

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