Allocation Using 'If/Then' Expression with Flag Column Generates Wrong Results
Last updated on JULY 01, 2016
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Profitability Management (PFT), when you run a Static Driver Allocation whose "Source" screen uses an Expression with an if/then statement that includes a flag column, the Allocation is generating the wrong result. Below is an example of the Expression:
If CUSTOM_ASSET_LIAB_FLAG = 1, use NET_INT_INC_EXP - TRANSFER_RATE_TOTAL
otherwise use TRANSFER_RATE_TOTAL - NET_INT_INC_EXP
Validating rows with CUSTOM_ASSET_LIAB_FLAG = 1, you find the Allocation is calculating the "otherwise" value of TRANSFER_RATE_TOTAL - NET_INT_INC_EXP" and generating a positive result when it should be calculating "NET_INT_INC_EXP - TRANSFER_RATE_TOTAL" and generating a negative value.
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