Customer Merge Is Failing on xla_third_party_merge_pub.third_party_merge package (Doc ID 2012027.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

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

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