My Oracle Support Banner

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

Last updated on MARCH 28, 2019

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 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) 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.