My Oracle Support Banner

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

Last updated on MARCH 14, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 5.5 to 5.5 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


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:


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.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.