BSP Calculate Running Very Slow for Single Product / Org After Installing New 'ofsrm' Executable (Doc ID 2177559.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP), after installing a patch that includes a new version of the 'ofsrm' executable, when you runs a Calculate for a single leaf level Product and Org Unit (with less than 6,000 records), the process is running for a very long time.  Before the patch was installed, the Calculate ran in a few minutes.  After installing the Patch, the cash flow engine process takes 1.5 hours.

Checking the ofsrm log file, it contains queries against tables like the following listed over and over until the log file is 1.5 GB in size:

FSI_IRCS
FSI_IRC_RATE_TERMS
FSI_IRC_RATE_HIST
FSI_FCAST_RATES_BUCKETS
FSI_FCAST_RATES_SCENARIOS
FSI_FCAST_IRCS
FSI_FCAST_IRC_STRCT_CHG_BKT
FSI_FCAST_IRC_STRCT_CHG_VAL
FSI_FCAST_IRC_DIRECT_INPUT
etc.

You expect the Calculate to run in the same time before and after patch is applied.

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