Stochastic RM 4.5 Process Using Forecast Balance ID Hangs (Doc ID 277930.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Risk Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Risk Manager - Version: 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

When running an Oracle Risk Manager (RM) Stochastic Process using a Forecast Balance ID, the process does not complete but appears to be hang.  Upon checking the result tables, some of the results are correctly written by the process.

In the server application log file, ofsrm.XXXXXX, there is an error message:

Running RM, Process ID: 102085 Configuration ID: 101771
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci
error
:
OCI Function: [4] - oexec(), oexn()
SQL Function: [3] - INSERT
Oracle Error: ORA-01426: numeric overflow
Driver Function:drv_oci::Execute()
SQL Statement: insert into EAR_LEAF_DTL_102085 (
leaf_node,rate_path_num,start_
date,end_date,earnings) values ( :leaf_node, :rate_path_num, :start_date,
:end_d
ate, :earnings )
Error(Oracle Financial Services Application error) (203055) Error
Bound Parameters:
:leaf_node = 1012107
:rate_path_num = 1
:start_date = 02/01/2007
:end_date = 01/31/2050
:earnings = -9.47258530255246e+157 SQL statement.


A previous run with no Forecast Balance ID completes successfully.

The Modeling Buckets in the active Configuration ID has a long term (several years) bucket as the last modeling horizon time bucket.

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