My Oracle Support Banner

Regulatory Retail Portfolio (Map_Ret_Exp) DT Failed with ORA-06502 Error (Doc ID 2875427.1)

Last updated on JUNE 14, 2022

Applies to:

Oracle Financial Services Basel Regulatory Capital Basic - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

The OOB DT named ''Regulatory Retail Portfolio'' part of Basel III batch is throwing error . Showing error of ''Error Msg :-> ORA-06502: PL/SQL: numeric or value error: character string buffer too small''.

In DT Log, below exception observed:

[INFO][BACKEND][OFSAA][RUNPROCEDURE] Statement to execute : BEGIN :D := DT_Map_Ret_Exp_1('1652718956258_28763208_20210930_1','20210930','$RUNID=1651576143131','$PHID=1651576143131~~JOB_16525287933102~~Job_1607416421702','$EXEID=PMFIND0079_a1a85a75-0711-4947-8709-8c6fd571f50f','$RUNSK=65','IND','Job_bad231f0740e42b1a1f8fa29e6236de9'); END;
Error Msg :-> ORA-06502: PL/SQL: numeric or value error: character string buffer too small

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


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