Exchange Rate Handling in Oracle Cloud

 Please find below a summary regarding exchange rate handling in Oracle Cloud:

• The exchange rate values in both RA_CUSTOMER_TRX_ALL and GL_DAILY_RATES are identical.

• However, the Fusion UI typically displays the exchange rate rounded to 6 decimal places. To ensure consistency, it is recommended to use ROUND(exchange_rate, 6) in custom reports or queries.

• The AutoInvoice interface (RA_INTERFACE_LINES_ALL) does not apply rounding by default, which can result in high-precision values being inserted—particularly when CONVERSION_TYPE is set to 'User' or a custom type.

Recommendations to Avoid High-Precision Exchange Rates:

• Round the exchange rate in FBDI templates, APIs, or integration sources before loading data.

• Ensure values in GL_DAILY_RATES are stored with a consistent precision (ideally up to 6 decimal places).

• Use ROUND(exchange_rate, 6) in all custom queries and reports to match how values are displayed in the Fusion UI.