Different Results Running Calculate at the Leaf Level vs Node Level for Rate Financial Elements in BSP 8.0.2.0.6

(Doc ID 2257947.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.6 to 8.0.2.0.7 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After upgrading from Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2.0.2 to BSP 8.0.2.0.6, when you run a 'Calculate' for a single COA and then re-run the same 'Calculate' at the node level for the COA, you get different results in the output.  Comparing the data in the RES_DTL_xxxxxx for the two Calculates, the Ending Rate and all rate related Financial Elements (FE) have different values.

For example, for FE 120, Ending Net Rate, the following exists in BUCKET_001:

Single value execution:
PRODUCT_ID: 14212006, RESULT_TYPE_CD: 1, FE 120: 272,159.15

Node value execution:
PRODUCT_ID: 14212006, RESULT_TYPE_CD: 1, FE 120: 394,333

Different results exist for other rate-related Financial Elements also: 130, 160, 170, 330, 360, 370, 440, 450, 500, 515, etc.

You did not have this issue in BSP 8.0.2.0.2 - only after installing BSP 8.0.2.0.6.  You expect the results to be the same whether you run the Calculate at the node level or level0.

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