Account Merge Ends With Error: Csi.Csi_acct_merge_pkg.Csi_ip_accounts_merge ORA-01403: No Data Found (Doc ID 947752.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Install Base - Version: 12.1 to 12.1.3 - Release: 12.1 to 12.1
Information in this document applies to any platform.

Symptoms

When attempting to merge account
the following error occurs:

ERROR
CSI.CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE
1 orig1 orig2 orig3 : 98193<>79430<>79431
CRM_MERGE.CUSTOMER_PRODUCTS_MERGE : 004- : ORA-01403: no data found

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Customer Accounts > Merge
2. Enter From Accout Number
3. Enter TO Account Number
4. Check Create Same Site for All Addresses
5. Click on Merged button
The merging request ends with error:
CSI.CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE
Updating table CSI_IP_ACCOUNTS
Updating table CSI_IP_ACCOUNTS

and from the CSI debug level 10 log file shows more detail of error as following.

MSG-00001: Updating table CSI_IP_ACCOUNTS 17-SEP-2009 04:16:14
MSG-00001: CSI:merged_records cursor... 17-SEP-2009 04:16:14
MSG-00001: 1 orig1 orig2 orig3 : 981937943079431 17-SEP-2009 04:16:14
MSG-00001: CRM_MERGE.CUSTOMER_PRODUCTS_MERGE : 004- : ORA-01403: no data found 17-SEP-2009 04:16:14
MSG-00001: ARP_CMERGE_MASTER.merge_crm_products : User-Defined Exception 17-SEP-2009 04:16:14 

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