BSP Interest Rate Scenario Fails to Load into Essbase Rates Cube
Last updated on SEPTEMBER 06, 2017
Applies to:Oracle Financial Services Balance Sheet Planning - Version 8.0.0 to 126.96.36.199.1 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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.
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