'Unable to find Rule deployed in plan type BSP in the repository' Errors in BSP (Doc ID 2070094.1)

Last updated on FEBRUARY 12, 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 Analytical Applications (OFSAA)
Oracle Financial Services Balance Sheet Planning (BSP)

Symptoms

On BSP 8.0.1, it appears that the rules are not found in BSP. When trying to execute functions in BSP and launch from a web form, it responds with a message that the calc ran successfully. The logs show warnings that the rules were not found. The rules in the log are deployed and can be viewed in planning.

The following errors can be seen:

ERROR

[2015-09-09T08:30:21.618-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1vzMg24aq45NVk3ye0006^j0007kP,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_FCAST_Ledger_Load_Seq deployed in plan type BSP in the repository.
]]
[2015-09-09T08:30:21.618-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1vzMg24aq45NVk3ye0006^j0007kP,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_LedgerTransform_Seq deployed in plan type BSP in the repository.
]]
[2015-09-09T08:30:21.618-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1vzMg24aq45NVk3ye0006^j0007kP,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_LedgerTransform_Seq deployed in plan type BSP in the repository.
]]
[2015-09-09T08:30:21.619-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1vzMg24aq45NVk3ye0006^j0007kP,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_Calculate deployed in plan type BSP in the repository.
]]
[2015-09-09T08:30:21.619-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1vzMg24aq45NVk3ye0006^j0007kP,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_FP_Partial_Seq deployed in plan type BSP in the repository.
]]
[2015-09-09T08:30:21.619-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1vzMg24aq45NVk3ye0006^j0007kP,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_UPA_Seq_CB deployed in plan type BSP in the repository.
]]
[2015-09-09T08:30:21.619-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1vzMg24aq45NVk3ye0006^j0007kP,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_UPA_Seq_NB deployed in plan type BSP in the repository.
]]
[2015-09-09T08:31:03.730-05:00] [Planning0] [WARNING] [HSP-0000008010] [oracle.EPMHSP.calcmgr_execution] [tid: 11] [userId: ] [ecid: 0057p1yVcz24aq45NVk3ye0006^j0007kZ,0:1] [APP: PLANNING (11.1.2.0)] [SRC_CLASS: com.hyperion.planning.calcmgr.HspCalcMgr] [SRC_METHOD: getRule] Failed to execute getRule()[[
Unable to find Rule BSP_PrctGrowth deployed in plan type BSP in the repository.
]]

In addition, the CFE does not appear to pull proper Process ID:

From the BSPCalculation_UnpricedAcc_udf.log:

2015-09-09 08:31:00,438 INFO com.oracle.bsp.udf.BSPCfeCall :: ================================================ Status : -1 Process Id : -999
2015-09-09 08:31:00,440 INFO com.oracle.bsp.udf.BSPCfeCall :: Procedure PR_RES_DET_IMPORT is not exceuted because CFE execution failed or function failed with generic exception
2015-09-09 08:31:00,440 INFO com.oracle.bsp.udf.BSPCfeCall :: --------------------------------------------------------
2015-09-09 08:31:00,440 INFO com.oracle.bsp.udf.BSPCfeCall :: importFunction not exceuted because CFE execution failed or function failed with generic exception
2015-09-09 08:31:00,440 INFO com.oracle.bsp.udf.BSPCfeCall :: ###################################################################
2015-09-09 08:31:00,440 INFO com.oracle.bsp.udf.BSPCfeCall :: Function failed with generic exception


The issue can be reproduced at will with the following steps:
1. Install 8.0
2. Run BSP Initialize
3. Upgrade to 8.0.1

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