Instrument to Ledger Allocation Not Converting Balances Back to Foreign Currency

(Doc ID 342866.1)

Last updated on JANUARY 11, 2006

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5
This problem can occur on any platform.


When running an Allocation that takes a foreign currency balance from an instrument table, multiplies it by a constant, and
outputs the record in the same foreign currency to the LEDGER_STAT table, the balance amount output to Ledger Stat is wrong.  The balance amount has been converted into the functional currency value even though the ISO_CURRENCY_CD is the foreign currency.  The balance is not being translated back into the foreign currency.


Functional Currency: USD
Foreign Currency: EUR

Instrument table balance: 15,725.00 EUR
Exchange Rates:
EUR to USD:  1.17834
USD to EUR:  0.848617

The allocation is doing the following:

1. Converts "Filter On" EUR Balance from the instrument table to Functional Currency USD
15,725.00 EUR * 1.17834 = $18,529.40

2. Multiplies this USD Balance by the constant (USD)
$18,529.40 * 1 = $18,529.40

3. Fails to convert the USD Balance back to the EUR value
-- A balance of 18,529.40 is output to Ledger Stat with ISO_CURRENCY_CD = EUR

The amount is not translated back into EUR.
($18,529.40 * 0.848617 = 15,725.00 EUR)


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