Ledger Stat Allocation Using Hierarchy Filter Not Generating Expected Output in PFT 5.5 (Doc ID 1347796.1)

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)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 5.5, if a Ledger Stat to Ledger Stat Allocation uses a Hierarchy Filter, the Allocation appears to aggregate the output data.  You did not design the Allocation to aggregate but instead use <Same As Source> in the Output screen.  The results are incorrect and there are fewer rows output than input.

Data appears to be aggregated by GL_ACCOUNT_ID, COMMON_COA_ID and PRODUCT_ID when a hierarchy filter is used.  For example:

Input:

GL_ACCOUNT_ID
COMMON_COA_ID
PRODUCT_ID
ORG_UNIT_ID
MONTH_12
112011
112011
112011
5014031
2,579,222.07
112011
112011
112011
5014032
2,455,065.91
112011
112011
112011
5014033
744,211.81
112011
112011
0
5014033
16,198.39


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.

Output:
GL_ACCOUNT_ID
COMMON_COA_ID
PRODUCT_ID
ORG_UNIT_ID
MONTH_12
112011
112011
112011
5014031
28,892,498.95
112011
112011
0
5014033
80,991.95

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:
  1. Create a Hierarchy Filter on Org Unit that selects a few Org Unit values that all have the same Common COA/Product values
  2. Create an Allocation and add the Hierarchy Filter to Org Unit in the Source screen
  3. Use <Same As Source> for all leaves or optionally set Financial Element to a specific value in the Output screen
  4. Run the Allocation
Review the output rows.   There will be less output rows than input rows.  The output is aggregated based on the Common COA/Product values.

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