How To Create Two Mapping Rules Which Write (Accumulate Results) Into the Same Account Table Column? (Doc ID 415174.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Goal

For an account table column, need the mapping rule result to be additive to the amount that already exists in that column.

For example, on the Mortgages account table, there is a single column called 'Transaction Expense'. This is meant to be populated with the sum of all transaction expense allocation results, which will be built up over several mapping rules.

For example, in the FEM_BALANCES table you have two different unit cost rates that will apply to mortgage transactions.  One Percent Distribution (% Dist) mapping rule takes the unit cost A from FEM_BALANCES multiplied by the Mortgages_Trans.Volume column for the transaction types that relate to that unit cost, then writes the result into the Transaction Expense column on the corresponding account record in the Mortgages table.  A second % Dist mapping rule takes the unit cost B multiplied by the volume on the transaction table for a different transaction type and writes the result back to the same Transaction Expense column for the same account record.


You want the result of the second mapping rule to add to the result of the first mapping rule.

In previous versions of Oracle Financial Services Applications (OFSA)/ Oracle Performance Analyzer (PA), this was achieved by including both allocation rules in a multi-page allocation.  How is Oracle Profitability Manager (PFT) 11i configured to achieve comparable functionality?

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