Customer Merge Is Failing on xla_third_party_merge_pub.third_party_merge package (Doc ID 2012027.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Customer is trying to merge customer A account with Customer B. Customer merge is failing.

Following error appears in log file:

MSG-00001: Calling xla_third_party_merge_pub.third_party_merge 14-MAY-2015 11:32:40
MSG-00001: p_original_third_party_id = 161133 14-MAY-2015 11:32:40
MSG-00001: p_original_site_id = -99 14-MAY-2015 11:32:40
MSG-00001: p_new_third_party_id = 164137 14-MAY-2015 11:32:40
MSG-00001: p_new_site_id = -99 14-MAY-2015 11:32:40
MSG-00001: x_retcode = E 14-MAY-2015 11:32:40
MSG-00001: Others Error in insert_full_merge_event User-Defined Exception 14-MAY-2015 11:32:40
MSG-00001:
x_retcode = E
Others Error in insert_full_merge_event User-Defined Exception 14-MAY-2015 11:32:40
MSG-00100: merge_products errored out
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()+14-MAY-2015 11:32:40
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()-14-MAY-2015 11:32:40


NOTE: This issue is happening for one customer only, other customers and sites merge without error.

Cause

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