Error During Customer Merge Updating Tables FII_AR_PMT_SCHEDULES_F and FII_COLLECTORS (Doc ID 2147720.1)

Last updated on JUNE 08, 2016

Applies to:

Oracle Financials Intelligence - Version 12 and later
Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, CDM Merge

You have a duplicate customer account number set and you need to merge one account with another account.  You are using the Standard customer merge process but it's failing with the error:

MSG-00001: Updating table FII_AR_PMT_SCHEDULES_F 17-FEB-2016 08:07:56
MSG-00001: row(s) updated 17-FEB-2016 08:07:56
MSG-00001: Updating table FII_COLLECTORS 17-FEB-2016 08:07:56
MSG-00001: MERGE_COLLECTOR_ACCOUNTS 17-FEB-2016 08:07:56
MSG-00001: ARP_CMERGE_MASTER.merge_crm_products : User-Defined Exception 17-FEB-2016 08:07:56
MSG-00001:
MERGE_COLLECTOR_ACCOUNTS
ARP_CMERGE_MASTER.merge_crm_products : User-Defined Exception 17-FEB-2016 08:07:56
MSG-00100: merge_products errored out
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()+17-FEB-2016 08:07:56
MSG-00100: ARP_CMERGE_MASTER.clear_error_merge_rows()-17-FEB-2016 08:07:56



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