BSP Calculate Fails with 'import execution failed' and 'Substitution variable <app>.BSP.VW_RES_DTL_NB does not exist'

(Doc ID 2310990.1)

Last updated on OCTOBER 02, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.8 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.0.8, when you run a Calculate, the cash flow engine executes successfully but the results fail to upload into Essbase.  There are no results displayed in the Financial Plan Default form.  The following messages exist at the end of the BSPCalculation_UnpricedAcc_udf.log from $EPM_ORACLE_HOME/logs/bsplog:

2017-09-25 15:56:35,972 INFO com.oracle.bsp.udf.BSPCfeCall :: ###################################################################
2017-09-25 15:56:35,972 INFO com.oracle.bsp.udf.BSPCfeCall :: financial plan procedure PR_FINANCIAL_PLAN executed sucessfully
2017-09-25 15:56:35,972 INFO com.oracle.bsp.udf.BSPCfeCall :: Function called sucessfully and returning process id 201424
2017-09-25 15:56:35,972 INFO com.oracle.bsp.udf.BSPCfeCall :: CFE executed successfully
2017-09-25 15:56:35,972 INFO com.oracle.bsp.udf.BSPCfeCall :: procedure executed sucessfully with process id after the sucessful execution of the CFE
2017-09-25 15:56:35,972 INFO com.oracle.bsp.udf.BSPCfeCall :: import execution failed during the business rule execution
2017-09-25 15:56:35,972 INFO com.oracle.bsp.udf.BSPCfeCall :: ###################################################################


You also find the following error in the Config_FileCall.log:

2017-09-25 15:56:35,966 INFO com.oracle.bsp.configuration.ClsConfigurationFactory :: ERROR: Cannot delete variable. Essbase Error(1051083): Substitution variable BSP_PARC.BSP.VW_RES_DTL_NB does not exist

This error appears to prevent the cash flow engine results from getting uploaded to Essbase.

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