PFT: Mapping Rule Which Aggregates From Account Table To Balance Table Does Not Translate the Currency

(Doc ID 465716.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Profitability Manager - Version: 11.5.10
Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.


On 11.5.10, the amount in source table is not translated to the amount in fem_balances table.

Expect the engine to translate the amount from other currency to the functional currency of the ledger.

The issue can be reproduced at will with the following steps:
1) Set exchange rate for both currencies for the last day of the calendar period.
2) Define mapping rule to debit FEM_BALANCES from the account table column with the amount.
3) Load data to account table
6) Execute mapping rule
7) Check fem_balances.
In XTD_BALANCE_F has the exact same amount as in the source column from the account table, so no translation is applied.


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