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)

Symptoms

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 com.oracle.bsp.udf.BSPProcedureCall :: {call PR_MATURITY_MIX_OVERRIDE(?,?,?,?,?,?,?)}
2016-05-25 10:36:24,452 INFO com.oracle.bsp.udf.BSPProcedureCall :: 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 com.oracle.bsp.udf.BSPProcedureCall :: 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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms