- OracleApps Epicenter - http://www.oracleappshub.com -

Dealing with Foreign Currency :Translation

Similar to Revaluation [1], there is another term called 'Translation' , a feature that linked with Foreign Currency transactions in General Ledger.

Translation

Translation is used to translate an entire set of books or balances for a company from the functional currency to a foreign currency.

This feature can translate both actual and budget balances. If the system have enabled average balance processing then the system can translate average balances as well.

Translation is frequently used to prepare financial reports for consolidation into global financial statements.

Translation uses periodic rates and, optionally, historical rates in compliance with FASB52.

FASB stands for Financial Accounting Standards Board which is a group within the Accounting field that issues bulletins on how to account for various financial events.

How does the system translate balances?

As per Metalink Note [2] 1061166.6 [2], FASB52 states that when translating a Trial Balance from one currency to another, the following conventions should be used:

How does the system translate balances?

Assets and liabilities are translated by multiplying the YTD balance by the Period End Rate.

YTD (translated currency) = Rate X YTD (functional currency)

Whereas,revenue and Expense balances are translated using the PTD balance for each period and the corresponding Period Average rate for each period; therefore, translation must be performed for the first period of the fiscal year forward to the period for which translation is required. Rates must also exist in the Period Rates table back to the first period of the fiscal year in which the translation is being performed.

PTD (translated currency) = Rate X PTD (functional currency)

In the Stock and Ownership Equity accounts, historical rates are generally used. but there are certain other special cases requiring the use of Historical rates.

Point that should be noted is EBS GL allows the use of an amount to be used as the translated balance for the account specified rather than calculating the amount using the Historical Rates. This feature allows the translated balance to be calculated outside of the application in lieu of setting up and maintaining the Historical Rates. Historical Rate usage is set up by specifying a range of accounts to use Historical Rate translation. This set-up overrides the above rules for using the Period End and Period Average rates.

Cumulative Translation Adjustment Account

Since the Balance Sheet and the Profit and Loss accounts are being translated using different rates, the translated Trial Balance is no longer in balance. The amount required to bring the foreign Trial Balance back in balance is called the Cumulative Translation Adjustment or CTA. This account is specified in the Set of Books set-up screen. The accounts and the amounts in them are created and populated dynamically when the Translation process get completed successfully.

You should note that CTA is typically a Balance Sheet account, the account type is determined when the account value is defined for the account

Some of the underline report for Translation :

..What happen in Oracle when Translation Run?

Translation is very table-space intensive. When this run its roughly doubling one period of data held in the GL_BALANCES table.

Suggested Reading at Metalink

Related Posts in series for "Dealing with Foreign Currency"

  1. Dealing with Foreign Currency : "Revaluation" [1]
  2. Dealing with Foreign Currency :"Translation"

3 Comments (Open | Close)

3 Comments To "Dealing with Foreign Currency :Translation"

#1 Comment By venkatesh On December 17, 2007 @ 7:00 am

Article is very good. But not clear about “Whereas,revenue and Expense balances are translated using the PTD balance for each period and the corresponding Period Average rate for each period; therefore, translation must be performed for the first period of the fiscal year forward to the period for which translation is required. Rates must also exist in the Period Rates table back to the first period of the fiscal year in which the translation is being performed”. Support i have 12 monthly period. I want to run tanslation by 31st Dec, so it will translate by monthly balances for earch perio or it will run for dec by taking YTD balance. Another question is is there any condition for transalation like prior period and following period should be open.

#2 Pingback By International Financial Reporting Standards (IFRS) Oracle White Paper | OracleApps Epicenter On May 21, 2009 @ 2:47 am

[…] Translation : Check it out for definition here.GL translation is compliant with both US GAAP and IFRS standards. […]

#3 Comment By Blr_18 On January 12, 2013 @ 12:57 am

not very cler want understand entire navigation to do the translation in oracle R12,

Please help me.