Skip to main content
Integration with Oracle Fusion Tax
Search
Search Indirect Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE Determination,ONESOURCE Indirect Tax
  • Subject: Integration

Exchange rates based on currency conversion date

ONESOURCE Indirect Tax Determination uses the
Tax Determination Date
 to set the
Tax Currency Conversion Date
 in Fusion Cloud.
Oracle Fusion uses a conversion date to determine the exchange rate. This applies when the invoice currency differs from the associated tax currency. For example, an invoice can use USD while the tax is calculated in EUR. Oracle uses the conversion date to convert the amount into the ledger currency before storing the tax details in the
ZX_LINES
 table.
Previously, Oracle Fusion used the invoice date as the default conversion date. This behavior could apply an inaccurate exchange rate when the
Tax Determination Date
 differed from the invoice date.
The
Tax Currency Conversion Date
 maps the Oracle Fusion response directly from the ONESOURCE Indirect Tax Determination response. Oracle Fusion now uses the
Tax Determination Date
 for currency conversion instead of the invoice date.
This change helps Oracle Fusion apply the correct exchange rate. It also improves tax calculation accuracy and keeps currency conversion consistent with the external tax engine.

Turn on currency conversion date

  1. Go to the
    ERP Settings
     screen.
  2. Select
    Tools
    Integration
    Oracle Cloud ERP
    Oracle ERP Settings
     tab.
  3. Turn on
    Set Tax Currency Conversion Date from Tax Determination Date
    .

Processing details

Tax Currency Conversion Date
 mapping provides the following functionality:
  • Uses the
    tax_determination_date
    from the ONESOURCE Indirect Tax Determination response.
  • Updates
    zx_lines.tax_currency_conversion_date
     with the
    Tax Determination Date
    .
  • Lets Oracle Fusion tax calculate the exchange rate from the
    Tax Determination Date
     and tax setup.
  • Populates
    tax_currency_conversion_rate
    and
    tax_currency_conversion_type
    .
note
Verify that the
Conversion Rate Type
 is updated for taxes in the
Manage Taxes
 setup.