Stochastic RM 4.5 Process Using Forecast Balance ID Hangs
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.
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
OCI Function:  - oexec(), oexn()
SQL Function:  - INSERT
Oracle Error: ORA-01426: numeric overflow
SQL Statement: insert into EAR_LEAF_DTL_102085 (
date,end_date,earnings) values ( :leaf_node, :rate_path_num, :start_date,
ate, :earnings )
Error(Oracle Financial Services Application error) (203055) Error
: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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms