Foreign exchange gains and losses report

Summary:

As a global company, with entities using +50 currencies, we'd like to see a report to understand what is generating the foreign exchange gains and losses at the GL consolidated ledger.

Content (required):

The report should include information from GL such as period, ledger, date, full concatenated segments, net entered, document currency, net accounted, ledger currency, JE description, Batch number, source, category. The option to drill down to the invoice, supplier, customer, etc from the subledger that created the amount would be ideal.

At the moment, this analysis is very time consuming and Oracle does not have an efficient way to report on this data.