Running Current Position and New Business BSP Process is Hanging (Doc ID 1966255.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.1 and later
Information in this document applies to any platform.

Symptoms

On Oracle Financial Services Balance Sheet Planning (BSP) 6.1, previously working current position processes are now all failing and showing with status stuck in "Ongoing"

Also from the database side, data is not getting inserted into the result detail tables.

ERROR

2015-01-22 17:03:54,395 INFO com.oracle.bsp.udf.BSPExtComponet :: BSP_201260_20141231
2015-01-22 17:03:54,395 INFO com.oracle.bsp.udf.BSPExtComponet :: /app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/bin/ofsrm.sh BSP_201260_20141231 OFSRM TASK1 20141231 201260 ADMIN BSP BSP
2015-01-22 17:03:54,395 INFO com.oracle.bsp.udf.BSPExtComponet :: Directory : /app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/bin
2015-01-22 17:03:54,396 INFO com.oracle.bsp.udf.BSPExtComponet :: command : /app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/bin/ofsrm.sh BSP_201260_20141231 OFSRM TASK1 20141231 201260 ADMIN BSP BSP
2015-01-22 17:03:54,403 INFO com.oracle.bsp.udf.BSPExtComponet :: Getting the process status
2015-01-22 17:03:54,403 INFO com.oracle.bsp.udf.StreamGobbler1 :: EPM_ORACLE_HOME : /app/hpp/Oracle/Middleware/EPMSystem11R1
2015-01-22 17:03:54,410 INFO com.oracle.bsp.udf.StreamGobbler1 :: OS
2015-01-22 17:03:54,459 INFO com.oracle.bsp.udf.StreamGobbler1 :: Warning: iso88951 does not exist.
2015-01-22 17:03:54,461 INFO com.oracle.bsp.udf.StreamGobbler1 :: Additional parameters will be ignored
2015-01-22 17:03:54,461 INFO com.oracle.bsp.udf.StreamGobbler1 :: AES_JAR_PATH = -Djava.class.path=/app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/lib/bspudf.jar:/app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/lib/ess_japi.jar:/app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/lib/log4j-1.2.14.jar:/app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/lib/xmlparserv2.jar
2015-01-22 17:03:54,571 INFO com.oracle.bsp.udf.StreamGobbler1 :: [handleJVM]->INFO: JVM created successfully...
2015-01-22 17:03:54,956 INFO com.oracle.bsp.udf.StreamGobbler1 :: AES Instance : null
2015-01-22 17:03:55,406 INFO com.oracle.bsp.udf.StreamGobbler1 :: AES Instance returned : com.iflex.fic.util.AESCryptor.AESCryptor@266bade9
2015-01-22 17:03:55,427 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2015-01-22 17:03:55,427 INFO com.oracle.bsp.udf.StreamGobbler1 :: | strBatchId : BSP_201260_20141231 | strComponentId : OFSRM | Process ID : 201260 | User ID : ADMIN |
2015-01-22 17:03:56,284 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2015-01-22 17:03:56,284 INFO com.oracle.bsp.udf.StreamGobbler1 :: ProcSysID = 201260
2015-01-22 17:03:56,570 INFO com.oracle.bsp.udf.StreamGobbler1 :: Running Oracle ALM, Process Rule: 201260 Engine started execution
2015-01-22 17:03:56,570 INFO com.oracle.bsp.udf.StreamGobbler1 :: 1 | OFSAA.EXEC_STARTED | INFORMATION
2015-01-22 17:03:57,310 INFO com.oracle.bsp.udf.StreamGobbler1 :: Setting Strategy Flag
2015-01-22 17:03:57,310 INFO com.oracle.bsp.udf.StreamGobbler1 :: Setting Custom1 Flag
2015-01-22 17:03:57,350 INFO com.oracle.bsp.udf.StreamGobbler1 :: Strategy Leaf : 5
2015-01-22 17:03:57,350 INFO com.oracle.bsp.udf.StreamGobbler1 :: custom1_leaf : 6
2015-01-22 17:04:04,209 INFO com.oracle.bsp.udf.StreamGobbler1 :: TPWrapper Class is initialized
2015-01-22 17:14:38,239 INFO com.oracle.bsp.udf.StreamGobbler1 :: /app/hpp/Oracle/Middleware/EPMSystem11R1/products/Planning/bin/ofsrm.sh: line 19: 24202 Killed $EPM_ORACLE_HOME/products/Planning/bin/ofsrm $1 $2 $3 $4 $5 $6 $7 $8
2015-01-22 17:14:38,239 INFO com.oracle.bsp.udf.BSPExtComponet :: Final CFE return status :137
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPExtComponet :: CFE execution Failed
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: CallRunOff_proc is not executed either CFE execution failed or its not a new Bussiness scenario
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: RUNOFF CFE call completes ********
2015-01-22 17:14:38,240 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.
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: ================================================
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: Status : -9999 Process Id : 201260
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: Procedure PR_RES_DET_IMPORT is not exceuted because CFE execution failed or function failed with generic exception
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: --------------------------------------------------------
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: importFunction not exceuted because CFE execution failed or function failed with generic exception
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: ###################################################################
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: ************************************************
2015-01-22 17:14:38,240 INFO com.oracle.bsp.udf.BSPCfeCall :: Function called sucessfully and returning process id 201260
2015-01-22 17:14:38,241 INFO com.oracle.bsp.udf.BSPCfeCall :: ++++++++++++++++++++++++++++++++++++++++++++++++++++
2015-01-22 17:14:38,241 INFO com.oracle.bsp.udf.BSPCfeCall :: CFE execution failed
2015-01-22 17:14:38,241 INFO com.oracle.bsp.udf.BSPCfeCall :: executed CFE status is -9999

The issue can be reproduced at will with the following steps:
1. Run current position process on FSI_D_TERM_DEPOSITS and FSI_D_LOAN_COMMITMENTS

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