'ORA-01438: VALUE LARGER THAN SPECIFIED PRECISION ALLOWED' Error in FSI_BSP_PROCESS_LOG (Doc ID 2175212.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2.0.2, when you run a Calculate using a node level Entity and a leaf level Chart of Account, you get the following error in the table FSI_BSP_PROCESS_LOG:

V_PROCESS_CODE: FN_BSP_PROCESSING
V_PROCESS_TYPE: POPULATION OF BSP PROCESSING TABLES
V_PROCESS_STATUS: FAILED
V_EVENT_MESSAGE: [MSG-FATAL]: ERROR OCCOURED WHILE POPULATING BSP PROCESSING TABLES [ORA:ERR] ORA-01438: VALUE LARGER THAN SPECIFIED PRECISION ALLOWED FOR THIS COLUMN

The last action referenced in the $EPM_ORACLE_HOME/logs/bsplog/DBProcsFuncs_PAttrs_Call.log is the following:

Going to remove cache for process id=200789 Qry:select distinct (select ORG_UNIT_CODE from DIM_ORG_UNIT_B where ORG_UNIT_ID=org.eid) from (select column_value as eid from table(fn_get_leaves(?, 2)) ) org
removed the cached entity for process sysId:200789 rest in Entitycoas in nb run:{1513001=130015010~130015010~132010010~125010010,... followed by a list of Entities


The Cash Flow Engine process executes but fails because the definition data is incomplete.  The following error exists in BSPCalculation_UnpricedAcc_udf.log:

Procedure PR_RES_DET_IMPORT is not exceuted because CFE execution failed or function failed with generic exception

You do not know what is triggering the errors.

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