RAXMRG: Customer Merge while using MOAC ends in ORA-06502: PL/SQL: numeric or value error: character string buffer too small
(Doc ID 2140281.1)
Last updated on SEPTEMBER 01, 2024
Applies to:
Oracle Trading Community - Version 12.1.3 and later Oracle Receivables - Version 12.2.6 and later Information in this document applies to any platform.
Symptoms
While running 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: HZ_DQM_SYNC.stage_account_merge()+ 28-FEB-2016 10:03:02 MSG-00001: HZ_DQM_SYNC.stage_account_merge error - ORA-06502: PL/SQL: numeric or value error: character string buffer too small 28-FEB-2016 10:03:02 MSG-00001: ARP_CMERGE_MASTER.delete_rows : ORA-06502: PL/SQL: numeric or value error: character string buffer too small 28-FEB-2016 10:03:02 MSG-00100: 100 processing error MSG-00100: processing_error MSG-00100: ARP_CMERGE_MASTER.reset_merge_rows()+28-FEB-2016 10:03:02
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Responsibility: Trading Community Manager 2. Navigation: Data Quality Management > Account Merge 3. Populate the To and From accounts > Run the Merge > Review the output log and notice the error message
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!