Function FSI_MERGE_REP_PORFOLIO_STRIPS Fails With Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small
(Doc ID 3008710.1)
Last updated on MAY 23, 2024
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.7.4.0 to 8.1.1.1 [Release 8 to 8.1]Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Symptoms
In FTP, the transform data batch which executes the seeded PLC function FSI_MERGE_REP_PORFOLIO_STRIPS is failing with errors in fsi_message_log:
ERROR
ORA-06502
MISDATE - MERGE REP PORTFOLIO ::: 20240229
error occured while merging the strips in replicating portfolio for pattern id : 80003[ORA:ERR] ORA-06502: PL/SQL: numeric or value error: character string buffer too small
The issue appears to be caused by variables which are too small in the function, need to increase the length of the variables into 5000 in function FSI_MERGE_REP_PORFOLIO_STRIPS with the following:
STRIPLIST VARCHAR2(5000);
STR_QUERY VARCHAR2(5000);
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 |
| Cause |
| Solution |
| References |