My Oracle Support Banner

'Calculate Current Business' at Total Bank Level Gets Stuck in Processing Status During Import into Essbase (Doc ID 2176188.1)

Last updated on MARCH 28, 2019

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




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

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