My Oracle Support Banner

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

Last updated on MARCH 26, 2021

Applies to:

Oracle Risk Manager - Version 4.5.39 and later
Oracle Financial Services Asset Liability Management - Version 5.1 to 8.0.2 [Release 5 to 8]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Note: All OFSA 4.5 products have reached sustaining support.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.