RAXMRG: Customer Merge While Using MOAC Ends In ORA-06502 (Doc ID 2267945.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Trading Community - Version 12.0 and later
Oracle Customers Online - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

On : 12 version, CDM Merge

When attempting to run the Customer merge for two accounts while using Multiple Organization Access Control (MOAC), the process ends with the following error message in the log:

ERROR
-----------------------
MSG-00001: ARP_CMERGE_ARCPF.delete_rows()-
MSG-00001: Sync parties of deleted accounts, call hz_dqm_sync.stage_account_merge
MSG-00001: HZ_DQM_SYNC.stage_account_merge()+
MSG-00001: HZ_DQM_SYNC.stage_account_merge error - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
MSG-00001: ARP_CMERGE_MASTER.delete_rows : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
MSG-00100: 100 processing error
MSG-00100: processing_error


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Customers Online Data Librarian Superuser
2. Navigation: Data Quality > Account Merge Requests
3. Create a new merge request and Populate the To and From accounts > Run the Merge

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