My Oracle Support Banner

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

Last updated on JUNE 18, 2021

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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