Customer Merge Gives Error in IBY.IBY_MERGE.MERGE, Updating table IBY_TRXN_SUMMARIES_ALL (Doc ID 1996797.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to merge two customer sites, the Customer Merge Execution Report (RAXMRG module: Customer Merge) shows the following error:

ERROR
------------
IBY.IBY_MERGE.MERGE
Updating table IBY_TRXN_SUMMARIES_ALL
 row(s) updated

 

Other customer sites are able to merge successfully.  The issue appears to be specific to these two customer sites. 

FND logs were generated, but these did not contain any specific errors:

Start of Proc:Customer Merge
Customer Account Id:3836
Customer Merge Header Id:38021
Credit Usage Delete Flag:N
Transferring the  Payer Records
Transferring the  Payer Records
checking if a site is already updated
checking if a site is already updated
l_payer_count after fetching: 0
l_payer_count after fetching: 0
After checking of a site already updated
After checking of a site already updated
checking if a site is already updated
checking if a site is already updated
l_payer_count after fetching: 0
l_payer_count after fetching: 0
After checking of a site already updated
After checking of a site already updated
checking if a site is already updated
checking if a site is already updated
l_payer_count after fetching: 0
l_payer_count after fetching: 0
After checking of a site already updated
After checking of a site already updated
Performing Transaction summary Merge
Performing Transaction summary Merge
Performing Transaction Extensiopns Merge
Performing Transaction Extensiopns Merge
Updating the instrument Assignment Id...
Updating the instrument Assignment Id...
Transferring the  Payer Records
Transferring the  Payer Records
checking if a site is already updated
checking if a site is already updated
l_payer_count after fetching: 0
l_payer_count after fetching: 0
After checking of a site already updated
After checking of a site already updated
checking if a site is already updated
checking if a site is already updated
l_payer_count after fetching: 0
l_payer_count after fetching: 0
After checking of a site already updated
After checking of a site already updated
checking if a site is already updated
checking if a site is already updated
l_payer_count after fetching: 0
l_payer_count after fetching: 0
After checking of a site already updated
After checking of a site already updated
Performing Transaction summary Merge
Performing Transaction summary Merge
Performing Transaction Extensiopns Merge
Performing Transaction Extensiopns Merge
Updating the instrument Assignment Id...
Updating the instrument Assignment Id...
Constructing filepath.  Appl=CSI, name=US, type_name=MESG, write_flag=0
/u01/app/applpch/apps/apps_st/appl/csi/12.0.0/mesg/US.msb
Constructing filepath.  Appl=FII, name=US, type_name=MESG, write_flag=0
/u01/app/applpch/apps/apps_st/appl/fii/12.0.0/mesg/US.msb

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