After Upgrade to BSP 8.0.2.0.1 Import Current Position Fails With 'import execution failed during the business rule execution' Essbase Import Errors

(Doc ID 2155245.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)

Symptoms

After upgrading to BSP 8.0.2.0.1 the import of current position into Essbase fails within the final call to Essbase load rule "impCBCC1.rul" with the following error. It appears to be prefixing the DSN with $OCI$:

ERROR
From the BSPCalculation_UnpricedAcc_udf.log:

2016-06-16 16:40:05,342 INFO com.oracle.bsp.udf.BSPImport :: deleted file /app/hpp/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/app/BSP/BSP/P4404486.csc
2016-06-16 16:40:05,342 INFO com.oracle.bsp.udf.BSPCfeCall :: ================================================ Status : 0 Process Id : 202240
2016-06-16 16:40:05,465 INFO com.oracle.bsp.udf.BSPCfeCall :: --------------------------------------------------------
2016-06-16 16:40:07,652 INFO com.oracle.bsp.udf.BSPCfeCall :: importFunction executed sucessfully with return dataLoad_status : 1
2016-06-16 16:40:07,666 INFO com.oracle.bsp.udf.BSPCfeCall :: ###################################################################
2016-06-16 16:40:07,666 INFO com.oracle.bsp.udf.BSPCfeCall :: Function called sucessfully and returning process id 202240
2016-06-16 16:40:07,666 INFO com.oracle.bsp.udf.BSPCfeCall :: CFE executed successfully
2016-06-16 16:40:07,666 INFO com.oracle.bsp.udf.BSPCfeCall :: procedure executed sucessfully with process id after the sucessful execution of the CFE
2016-06-16 16:40:07,666 INFO com.oracle.bsp.udf.BSPCfeCall :: import execution failed during the business rule execution
2016-06-16 16:40:07,666 INFO com.oracle.bsp.udf.BSPCfeCall :: ###################################################################

From the Essbase logs:

Reading Rule SQL Information For Database [BSP]
Reading Rules From Rule Object For Database [BSP]
Substitution Variable in Data Source Name detected. Using: [$OCI$HPP_BSP] as DSN
EssOCI is enabled to extract data from the Oracle database
SELECT Statement [SELECT YEAR_VALUE,
PERIOD_NAME,
BUCKET_VAL / FN_BSP_CCY_FACTOR('BSP'),
PRODUCT_ID,
STRATEGY_ID,
  Custom1,
CCY_CD,
ORG_UNIT_ID,
CASE WHEN FINANCIAL_ELEM_ID = 'C70' THEN 'AC70'
WHEN FINANCIAL_ELEM_ID = 'C80' THEN 'AC80'
WHEN FINANCIAL_ELEM_ID = 'C90' THEN 'AC90'
WHEN FINANCIAL_ELEM_ID = 'C91' THEN 'AC91'
WHEN FINANCIAL_ELEM_ID = 'C92' THEN 'AC92'
WHEN FINANCIAL_ELEM_ID = 'C93' THEN 'AC93'
WHEN FINANCIAL_ELEM_ID = 'C94' THEN 'AC94'
WHEN FINANCIAL_ELEM_I] is generated
EssOCI is initializing the connection to Oracle database on server [HPP_BSP]
EssOCI failed to connect to Oracle database with error message [ORA-12154: TNS:could not resolve the connect identifier specified
]
Failed to Establish Connection With SQL Database Server. See log for more information
Unexpected Essbase error 1021001


The issue can be reproduced at will with the following steps:
1. Upgrade to BSP 8.0.2.0.1.
2. Execute current position.
3. Observe that no data is loaded to Essbase.
4. Inspect the Essbase log for the data load rule and identify the error.

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