How to Get Mapping Rule to Distribute Balance within the Same Dimension Value (%Dist-Leaf) (Doc ID 377575.1)

Last updated on JULY 31, 2010

Applies to:

Oracle Profitability Manager - Version: 11.5.10 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance 31-Jul-2010.

Goal

In Profitability Manager, how can you setup a Mapping Rule to perform a percent distribution calculation to distribute balances within a specific dimension value?

Normally, the dimension set to "Percent Distribution" in the Percent Distribution screen is used to distribute costs across all values. In this case, the Mapping Rule needs to distribute balances within a specific dimension.

For example, there are two Cost Centers -- Cost Center A and Cost Center B. Cost Center A has 3 products that total $150,000. Cost Center B has 3 products that total $250,000 dollars. Instead of doing a normal percent distribution calculation that would distribute the total of the two Cost Centers -- $400,000 -- across all dimension values, the percent distribution needs to distribute the total of each individual Cost Center -- $150,000 and $250,000 -- to dimension values within that specific Cost Center.

In OFSA 4.5, this option was known as Percent Distribution-Leaf (%Distr-Leaf).

Note: This functionality was designed for use in Mapping Rules run against the FEM_BALANCES table.

Solution

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