Is There an Option to Create an Attribute Filter to Exclude Values? (Doc ID 2187358.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)

Goal

Want to allocate an amount subtracted by some other values for specific BUs.  The easiest way to identify those specific BUs is based on attributes defined at the BU level. This is the easiest way because the second option would be adding the actual BU codes (not taking into consideration the attribute anymore) in a data filter; however, this is very hard to maintain by the bank team, especially when new BUs appear in their business. Therefore, the second option is unacceptable.

Therefore, need an attribute filter with the exclude values option in the following allocation source:
FSI D MANAGEMENT LEDGER

FINANCIAL ELEMENT 23100
BUSINESS UNIT DIMENSION: SELECT BUSINESS UNIT FROM DIM_BUSINESS_UNIT_ATTR
WHERE ATTRIBUTE_ID = 1 AND DIM_ATTRIBUTE_NUMERIC_MEMBER NOT IN (#value)

Other possible workarounds which are rejected as not feasible:

• Using a data filter enables the use of the EXCLUDE option; however, in this case we should excludes values from BUSINESS_UNIT_ATTR table and our allocation does not work because our amount must be allocated from MANAGEMENT_LEDGER (the filter does not appear in the allocation definition screen)

• Using an expression; however, expressions are not supported with MANAGEMENT_LEDGER;

• Using more steps in the allocation flow to subtract our amounts from the initial one (by moving amounts from one FE to another), but in this case the performance of the process is very low and our allocations write too many rows.

Solution

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