Current Business Calculation Does Not Filter on All Selected Dimension Values

(Doc ID 2081820.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 to 8.0.2.0.1 [Release 8]
Information in this document applies to any platform.

Symptoms

On Oracle Financial Services Balance Sheet Planning (BSP) 8.0.1, when launching current business calculation for a specific value for CUSTOM1 dimension, all the values of the dimension are calculated instead of only the selected value.

ACTUAL BEHAVIOR
The Current Business Calculation is done for all the dimension values instead of only the selected values.

For example, after calculation is launched with only selected value ‘1’ (180000001) the output in the RES_DTL table, shows value for ‘1’ and ‘2’.

The log file also shows the same selections:

From the DBProcsFuncs_PAttrs_Call.log the following was chosen for calc:

2015-11-10 17:07:09,100 INFO  com.oracle.bsp.udf.BSPFunctionCall :: functionName  = {? = call FN_BSP_PROCESSING(?,?,?,?,?,?,?,?,?,?,?)} Product_id =  14212006 org_unit_id =  81520096 Ccy_id =  CAD strategy_id =  17000000 custom dimension1 id = 18000001 custom dimension2 id = 19000000 scenario_cd =  Budget version_cd =  Working business_type =  C balance_driver =  F700 pricing_driver =  F701

EXPECTED BEHAVIOR
Only the selected dimension values should be used in current position calculations.

The issue can be reproduced at will with the following steps:
1. Select values as follows: Product_id = 14212006 org_unit_id = 81520096 Ccy_id = CAD strategy_id = 17000000 custom dimension1 id = 18000001 custom dimension2 id = 19000000 scenario_cd = Budget version_cd = Working business_type = C balance_driver = F700 pricing_driver = F701
2. Launch current position calculation
3. Check RES_DTL table results

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