How To Configure a Mapping Rule To Subtract Items In Percent (%) Distribution Rule And Use Matched Dimensions

(Doc ID 579297.1)

Last updated on NOVEMBER 12, 2008

Applies to:

Oracle Profitability Manager - Version: 11.5.10
Oracle Enterprise Performance Foundation - Version: 11.5.10 to 12.0.4
Information in this document applies to any platform.

Goal

How to setup a percent distribution mapping rule to have a single column be both the matched and percent distribution dimension with subtraction.

For example, you have the following source and driver records:

Source Records

Financial Element
Line Item
Company Org
Department
Balance
457
966020
JAPAN
A1
100
457
966021
JAPAN
A2
200
457
966022
JAPAN
A3
300
457
966020
THAILAND
A1
400
457
966021
THAILAND
A2
500
457
966022
INDIA
A1
600

Driver Records

Financial Element
Line Item
Company Org
Department
Balance
30000
457573
JAPAN
B1
450
30000
457573
THAILAND
B2
845
30000
457573
INDIA
B3
596

You would like the following output records where the source balance records are summed by Company Org and then subtracted by the summed Company Org Driver records:

Output Records

Financial Elem
Line Item
Company Org
Department
Balance
30000
457573
JAPAN
SEAQ
150
30000
457573
THAILAND
SEAQ
55
30000
457573
INDIA
SEAQ
4

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