Balances Incorrectly Multiplied by X for Percent Distribution Rule with Hierarchy Dimension Component
Last updated on JUNE 30, 2010
Applies to:Oracle Profitability Manager - Version: 11.5.10 to 220.127.116.11 - Release: 11.5 to 11.5
Information in this document applies to any platform.
However, the outputted balances are not remaining the same. Instead, they are all being multiplied by a number that appears to be the same as the number of dimension values selected in a Hierarchy Dimension Component using "Node and Descendants Of" on the Source data. For example, if there are 27 company values included under the "Node and Descendants Of" selection in the Hierarchy Component, the outputted balances are all 27 times the original balance.
For example, when you input record has User Dim02 = 1100 and User Dim03 = 2500, set User Dim10 to "Midwest Center" while keeping the balance the same at $10,000. While the output record does have User Dim10 = "Midwest Center", the xtd_balance_f is now $270,000 instead of $10,000.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms