BSP Cashflow Engine Fails With ORA-12170 Errors (Doc ID 1901065.1)

Last updated on OCTOBER 04, 2016

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)
Oracle Financial Services Balance Sheet Planning (BSP)

Symptoms

In BSP 6.0.1, after migrating from working one BSP environment and attempting to run cashflow in new migrated instance. The User Interface shows successful process execution, but the following error is written in the log file:

ERROR

2014-06-19 16:27:35,119 INFO com.oracle.bsp.udf.StreamGobbler1 :: | strBatchId : BSP_200042_20131231 | strComponentId : OFSRM | Process ID : 200042 | User ID : ADMIN |
2014-06-19 16:28:17,239 INFO com.oracle.bsp.udf.StreamGobbler1 :: Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
2014-06-19 16:28:17,239 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2014-06-19 16:28:17,239 INFO com.oracle.bsp.udf.StreamGobbler1 :: OCI Function: [0] - olon(), orlon()
2014-06-19 16:28:17,239 INFO com.oracle.bsp.udf.StreamGobbler1 :: Oracle Error: [12170] - ORA-12170: TNS:Connect timeout occurred
2014-06-19 16:28:17,239 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2014-06-19 16:28:17,239 INFO com.oracle.bsp.udf.StreamGobbler1 :: Driver Function: drv_oci::Connect()

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