BSP Process that Loads Forecast Rates into Essbase Causing Temp Space Issue
Last updated on APRIL 14, 2017
Applies to:Oracle Financial Services Balance Sheet Planning - Version 18.104.22.168.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 22.214.171.124.6 version, Calculation Engine
When running the process to load the forecast rates into Essbase it is running out of temp space. This issue is only happening in one of the applications which has many interest rate codes with many terms. It appears to be generating 25 million rows based on interest rate codes/terms.
On other application that has a few interest rate codes with not as many terms defined, does not exhibit this problem. It still takes a while to run but does not deplete the temp space.
This only appears to effect users viewing the forecast rates in the application. The work around is creating custom query to pull the rates. The only change was to replace VW_FCAST_IRC_FLAT with FSI_FCAST_IRC_FLAT in the VIEW VW_FCAST_IRCS.
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