Allocation Using 'If/Then' Expression with Flag Column Generates Wrong Results (Doc ID 2155965.1)

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)

Symptoms

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.

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