RAXMRG: Customer Merge While Using MOAC Ends In ORA-06502
(Doc ID 2267945.1)
Last updated on JUNE 18, 2021
Oracle Trading Community - Version 12.0 and later Oracle Customers Online - Version 12.0 and later Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!