Customer Merge Is Failing on xla_third_party_merge_pub.third_party_merge package
Last updated on MAY 23, 2016
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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
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.
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