BSP Interest Rate Scenario Fails to Load into Essbase Rates Cube (Doc ID 2157045.1)

Last updated on AUGUST 19, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 to 8.0.2.0.1 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2, in 7. Forecast Rates > Interest Rate Scenario, when you run the import for Interest Rate Scenarios, no rates are loaded to the Rates Cube. The following message is output to Config_FileCall.log:

2016-06-29 15:11:37,628 INFO com.oracle.bsp.configuration.ClsConfigurationFactory :: Cube dataLoad Final Status :Data loaded but not calculated.

The following messages are output to the <app>.log usually found in $MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/essbase:

[Wed Jun 29 15:35:51 2016]Local/BSP_REG/Rates/admin@Native Directory/137/Info(1021006)
SELECT Statement [SELECT * FROM vw_fcast_ircs] is generated
.
.
.
[Wed Jun 29 15:35:51 2016]Local/BSP_REG/Rates/admin@Native Directory/137/Warning(1003035)
No data values modified by load of this data file

[Wed Jun 29 15:35:51 2016]Local/BSP_REG/Rates/admin@Native Directory/137/Info(1003051)
Data Load Elapsed Time for [SQL] with [ImpFIRC2.rul] : [0.14] seconds

You do not understand why the interest rate scenario import into Essbase fails.

Changes

 

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