BSP Calculate Running Very Slow for Single Product / Org After Installing New 'ofsrm' Executable
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Financial Services Balance Sheet Planning - Version 188.8.131.52.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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:
You expect the Calculate to run in the same time before and after patch is applied.
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