RM Process Hangs When Processing Remaining New Business for Specific Product / Currency Combination (Doc ID 1578585.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

In Oracle Risk Manager (RM) 4.5.39, an RM process hangs while on the "Remaining New Business" step.  The "ofsrm" process exists on the server but it does not appear to be processing records.  If you have the OFSA SQL debug on, the ofsrm.xxxxx.log file remains the same size.  No new SQL is added to it.

The RM process includes New Business with a Forecast Balance ID using the Target Growth method set to 0% for each bucket and New Business Timing set to "Distributed".  Some rows are output to the RES_DTL_xxxxx table for current position data but no New Business rows are output.

After testing various products on the instrument table, you find that the issue only occurs for a few Product / Currency combinations.  The issue also only occurs if you run the process with the New Business IDs against these Products / Currencies. The issue appears to be caused by a combination of instrument table data and the New Business setup.

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