BSP Current Business Cash Flow Fails with Error Message ORA-01455 (Doc ID 1646054.1)

Last updated on MAY 18, 2017

Applies to:

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

Symptoms

On Oracle Financial Services Balance Sheet Planning (BSP) 6.0.1, Current Business Cash Flow Fails with error message showing as below:

ERROR

2014-04-09 14:57:11,181 INFO  com.oracle.bsp.udf.StreamGobbler1 :: [handleJVM]->INFO: JVM created successfully...
2014-04-09 14:57:11,509 INFO  com.oracle.bsp.udf.StreamGobbler1 :: AES Instance : null
2014-04-09 14:57:11,875 INFO  com.oracle.bsp.udf.StreamGobbler1 :: AES Instance returned : com.iflex.fic.util.AESCryptor.AESCryptor@51b48197
2014-04-09 14:57:11,909 INFO  com.oracle.bsp.udf.StreamGobbler1 ::
2014-04-09 14:57:11,909 INFO  com.oracle.bsp.udf.StreamGobbler1 ::  | strBatchId : BSP_200083_20131130 | strComponentId : OFSRM | Process ID : 200083 | User  ID : ADMIN |
2014-04-09 14:57:13,694 INFO  com.oracle.bsp.udf.StreamGobbler1 ::
2014-04-09 14:57:13,694 INFO  com.oracle.bsp.udf.StreamGobbler1 :: ProcSysID = 200083
2014-04-09 14:57:13,694 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Running Oracle ALM, Process Rule: 200083mAppId : TM_Engine
2014-04-09 14:57:13,927 INFO  com.oracle.bsp.udf.StreamGobbler1 ::  Engine started execution
2014-04-09 14:57:13,927 INFO  com.oracle.bsp.udf.StreamGobbler1 :: 1 | OFSAA.EXEC_STARTED | INFORMATION
2014-04-09 14:57:15,438 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Setting Strategy Flag
2014-04-09 14:57:15,438 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Setting Custom1 Flag
2014-04-09 14:57:15,438 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Setting Custom2 Flag
2014-04-09 14:57:15,468 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Strategy Leaf :  5
2014-04-09 14:57:15,468 INFO  com.oracle.bsp.udf.StreamGobbler1 :: custom1_leaf :  6
2014-04-09 14:57:15,468 INFO  com.oracle.bsp.udf.StreamGobbler1 :: custom2_leaf :  7
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 ::
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 :: OCI Function: [12] - ofetch(), ofen()
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 :: SQL Function: [4] - SELECT
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Oracle Error: ORA-01455: converting column overflows integer datatype
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 ::
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 :: Driver Function: drv_oci::FetchNext()
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 ::
2014-04-09 14:57:28,880 INFO  com.oracle.bsp.udf.StreamGobbler1 :: SQL Statement: select rev_tab_columns_v.rev_data_type_cd,rev_tab_columns_v.display_name,rev_tab_columns_v.description,rev_tab_columns_v.property_column,rev_tab_columns_v.display_flg,rev_tab_columns_v.data_length, rev_tab_columns_v.data_precision,rev_tab_columns_v.data_scale,rev_tab_columns_v.column_order,rev_tab_columns_v.table_name,rev_tab_columns_v.owner,rev_tab_columns_v.column_name,

rev_tab_columns_v.dbf_name,rev_tab_columns_v.nullable,rev_tab_columns_v.data_type from rev_tab_columns_v where rev_tab_columns_v.table_name = 'FSI_D_LOAN_CONTRACTS'  and
rev_tab_columns_v.owner = 'BSP_PLAN_BSP' order by rev_tab_columns_v.display_name

...

2014-04-09 14:57:29,194 INFO  com.oracle.bsp.udf.StreamGobbler1 :: ofsrm: tmengine.cpp:1324: void TM_Engine::SetupPartitions(DBProcess*, DBHandle): Assertion `0' failed.
2014-04-09 14:57:29,924 INFO  com.oracle.bsp.udf.StreamGobbler1 :: /Hyperion/Oracle/Middleware/EPMSystem11R1/products/Planning/bin/ofsrm.sh: line 19: 12916 Aborted (core dumped) $EPM_ORACLE_HOME/products/Planning/bin/ofsrm $1 $2 $3 $4 $5 $6 $7 $8
2014-04-09 14:57:29,928 INFO  com.oracle.bsp.udf.BSPExtComponet :: Final CFE return status :134
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPExtComponet :: CFE execution Failed
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: CallRunOff_proc is not executed  either CFE execution failed or its not a new Bussiness scenario
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall ::  RUNOFF CFE call  completes ********
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: During jCallRunOff_proc call return status is FALSE.Stopping all the next dataload activities by making status_CFE = -9999.
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: ================================================
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: Status : -9999 Process Id : 200083
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: Procedure PR_RES_DET_IMPORT  is not exceuted because CFE execution failed or function failed with generic exception
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: --------------------------------------------------------
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: importFunction  not  exceuted because CFE execution failed  or function failed with generic exception
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: ###################################################################
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: ************************************************
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: Function called sucessfully  and returning process id 200083
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: ++++++++++++++++++++++++++++++++++++++++++++++++++++
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: CFE execution failed
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall ::  executed CFE status is -9999
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: --------------------------------------------------------
2014-04-09 14:57:29,929 INFO  com.oracle.bsp.udf.BSPCfeCall :: ###################################################################

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