BSP Process that Loads Forecast Rates into Essbase Causing Temp Space Issue (Doc ID 2255366.1)

Last updated on APRIL 14, 2017

Applies to:

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

Goal

On : 8.0.2.0.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.
 

Solution

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