Ledger Stat Allocation Using Hierarchy Filter Not Generating Expected Output in PFT 5.5
Last updated on SEPTEMBER 02, 2011
Applies to:Oracle Financial Services Profitability Management - Version: 5.5 to 5.5 - Release: 5 to 5
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Data appears to be aggregated by GL_ACCOUNT_ID, COMMON_COA_ID and PRODUCT_ID when a hierarchy filter is used. For example:
The Allocation's hierarchy filter selects all Org Unit ID values listed above. The input balances are multiplied by a constant of 5 and output to LEDGER_STAT.
28,892,498.95 = (2,579,222.07*5) + (2,455,065.91*5) + (744,211.81*5)
80,991.9 = 16,198.39*5
The data is aggregated and, as a result, not all Org Unit ID values appear in the output even though they are included in the hierarchy filter.
This issue does not occur if no data filter is used or if a "data element" filter is used.
Steps to Reproduce:
- Create a Hierarchy Filter on Org Unit that selects a few Org Unit values that all have the same Common COA/Product values
- Create an Allocation and add the Hierarchy Filter to Org Unit in the Source screen
- Use <Same As Source> for all leaves or optionally set Financial Element to a specific value in the Output screen
- Run the Allocation
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