Customer Account Merge Error :The value -1 is not a valid value for the parameter p_original_site_id. (Doc ID 2476484.1)

Last updated on SEPTEMBER 16, 2024

Applies to:

Symptoms

When attempting to run Party merge,
the following error occurs.

ERROR
-----------------------
MSG-00001: Updating table ar_receivable_applications  
MSG-00001: 0 row(s) updated 
MSG-00100: merge_products errored out
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()+ 
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()-

Debug Log

BEGIN - xla_third_party_merge.third_party_merge
p_source_application_id = 222, p_applicaiton_id = 222, p_ledger_id = 1, p_third_party_merge_date = 12-SEP-18, p_third_party_type = C
p_original_third_party_id = 295898, p_original_site_id = -1, p_new_third_party_id = 295899, p_new_site_id = -1, p_type_of_third_party_merge = FULL
p_mapping_flag = N, p_execution_mode = ASYNC_REQ, p_accounting_mode = F, p_transfer_to_gl_flag = Y, p_post_in_gl_flag = N
v_valuation_method_flag = N, g_use_ledger_security = N, g_access_set_id = 1000, g_sec_access_set_id = -1
The value -1 is not a valid value for the parameter p_original_site_id.
x_retcode = E, x_errbuf = Please inform your system administrator or support representative that: An unexpected error occurred in the function xla_third_party_merge.third_party_merge: The value -1 is not a valid value for the parameter p_original_site_id.
x_request_id = , x_event_ids.COUNT = 0
EXIT with ERROR - xla_third_party_merge.third_party_merge
x_retcode = E, x_errbuf = Please inform your system administrator or support representative that: An unexpected error occurred in the function xla_third_party_merge.third_party_merge: The value -1 is not a valid value for the parameter p_original_site_id.

Cause

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