Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Tausif Mulla
    Translation report for Foreign Currency Translation Reserve...
    Topic posted January 28, 2019 by Tausif MullaBronze Medal: 1,250+ Points, last edited February 6, 2019, tagged Configuration, Discussion Forums, Financials, Fusion, General Ledger, Help Center, OTBI, Reports, Sample Reports, Search, Security, Setup, Setup / Administration, Subledger Accounting 
    83 Views, 3 Comments
    Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.
    Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.


    Is there any report in Oracle cloud ERP for Foreign currency translation reserve reconciliation ? This will be part of translation process.

    Please suggest !




    • Angelo Cretella

      We have Several Ledgers in various functional/reporting currencies ultimatly all rolling up to a US reporting Parent.  

      I believe the only report available is to run a Trial Balnce report in reporting currency aka Translated Currency.  

      Be sure you set up your reporting ledgers.  You can check this by Navigating to "Mange Reporing Currencies

      Navigation can be found under your Implementation Project Under Financial in Setup and Maintenance.  or Financials>Define Common Applications Configuration for Financials>Define Ledgers>Define Accounting Configurations



    • Angelo Cretella

      If the above isn't what you are looking for, with a little Excel Manipulation, I will run a TB in Ledger Currency and Reporting Currency.  I will combine the data and pivot them and create a formula to back into the FX rate used for Translation.  That's the best I've been able to come up with since going live.