'Calculate Current Business' at Total Bank Level Gets Stuck in Processing Status During Import into Essbase

(Doc ID 2176188.1)

Last updated on NOVEMBER 22, 2016

Applies to:

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


In Oracle Financial Services Balance Sheet Planning (BSP), when you run 'Calculate Current Business' at the Total Bank top node level, the process hangs during the import back into Essbase.  The Cash Flow Engine calculation completes successfully and creates records in the RES_DTL_xxxxx table but BSP_Calculate_Current_Business continues to show a "Processing" status in the Job Console.

The BSPCalculation_UnpricedAcc_udf.log in $EPM_ORACLE_HOME/logs/bsplog shows the import executed successfully:

2016-06-20 15:24:10,063 INFO com.oracle.bsp.udf.BSPCfeCall :: importFunction executed successfully after the successful execution of the CFE and update statement executed successfully

The Config_FileCall.log contains the following message:

2016-06-20 15:24:10,056 INFO com.oracle.bsp.configuration.ClsConfigurationFactory :: Cube dataLoad Final Status :Data loaded but not calculated.

The application log, <app>.log, from /user_projects/epmsystem1/diagnostics/logs/essbase/essbase/app/<app>/ shows the following message at the bottom of the file:

[Mon Jun 20 15:24:10 2016]Local/BSP/BSP/admin@Native Directory/139950274537216/Info(1012677)
Calculating in serial

You do not understand why the Business Rule, BSP_Calculate_Current_Business, never completes the import process.


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