Allocation with Static Table Driver using Hierarchy Generates Wrong Results (Doc ID 1931433.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

On : 6.0.3 version, Allocation Entries

When attempting to run an Allocation using Static Table Driver that uses a Hierarchy and source Ledger Stat, the results of the calculation is multiplied by the number of leaf in the node specified in the hierarchy.

Steps:

1. Create Static Table Driver Allocation with Ledger Stat as the Source and Output on Ledger Stat.
For example:
Org           Amount
5014032          600
5014036        4200


2. Create Static Table Driver and use Org Hierarchy and specified coefficient at the node level.
In example below, the node has 8 leaves and coefficient specified is 2 at East Region level.

East Region - 1000002
  5010471
  5013964
  5014031
  5014032 -- match source
  5014033
  5014034
  5014036 -- match source
  5014037

3. Results in Ledger Stat shows:
Org            Amount  
5014032         9600  (600x2x8)
5014036       67200 (4200x2x8)

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