My Oracle Support Banner

Extract Maturity Mix Data Fails to Populate FSI_MATURITY_MIX_T with 'ORA-06502: PL/SQL: numeric or value error' (Doc ID 2156122.1)

Last updated on JULY 06, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.1.1 to 8.0.0 [Release 6 to 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


In Oracle Financial Services Balance Sheet Planning (BSP) 6.1.1, when you run the Extract Maturity Mix Data program for all COA / Entity combinations by selecting BSP_COA and BSP_Entities as the top nodes, the program populates FSI_BSP_MATURITY_MIX_T successfully but fails to move the data into FSI_MATURITY_MIX.

The following error exists in the DBProcsFuncs_PAttrs_Call.log from $EPM_ORACLE_HOME/log/bsplog:

2016-05-25 10:36:24,452 INFO :: {call PR_MATURITY_MIX_OVERRIDE(?,?,?,?,?,?,?)}
2016-05-25 10:36:24,452 INFO :: procedureName = {call PR_MATURITY_MIX_OVERRIDE(?,?,?,?,?,?,?)} p1 = BSP_COA p2 = BSP_Entities p3 = USD p4 = 6000 p5 = Forecast p6 = First Pass p7 = 90000
2016-05-25 10:36:24,535 INFO :: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1

There are no errors output to FSI_BSP_PROCESS_LOG for PR_MATURITY_MIX_OVERRIDE.  The error appears to prevent the population of FSI_MATURITY_MIX.


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

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