Instrument to Ledger Allocation Not Converting Balances Back to Foreign Currency
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
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
Million Knowledge Articles and hundreds of Community platforms