My Oracle Support Banner

Setup Of Party Merge Dictionary Party Merge Errors (Doc ID 336792.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Trading Community - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On 11.5.10 in Production:
The user has written a 'custom' package to assist with party merge.
The package is named xxtvl_merge_comm_pkg which merges records in the XXTVL_CDH_COMMUNICATIONS
table.

When party merge is ran the log file (ARHPMERGE) errors with
Verified the issue as noted below:
Log file (/Party_Merge_070905.txt)
shows the following error:
This unexpected SQL error occurred during the merge process :

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
.... One or more of the Merges in the batch had errors.
.... Please check the log file

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
References


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