Different Results Running Calculate at the Leaf Level vs Node Level for Rate Financial Elements in BSP 220.127.116.11.6
Last updated on JULY 19, 2017
Applies to:Oracle Financial Services Balance Sheet Planning - Version 18.104.22.168.6 to 22.214.171.124.7 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
After upgrading from Oracle Financial Services Balance Sheet Planning (BSP) 126.96.36.199.2 to BSP 188.8.131.52.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 184.108.40.206.2 - only after installing BSP 220.127.116.11.6. You expect the results to be the same whether you run the Calculate at the node level or level0.
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