My Oracle Support Banner

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 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance 31-Jul-2010.


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.


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.