Free Fusion SQLSetup & ConfigRead-only

Daily currency conversion rates loaded

Most recent FX rates per currency pair and conversion type — confirms multi-currency posting integrity.

Get the free ITGC & reporting query pack by email All 20 free queries

Tables used

gl_daily_rates

Bind parameters

None — the statement runs as written; edit the literals in the WHERE clause to narrow it.

How to run it

Paste it into a BI Publisher data model as a SQL data set, or into QueryWell's Query Studio and run it against your pod with a reporting account. Results come back to a grid you can profile, chart and export with a SHA-256 hash.

SQLdba-setup-currency-rates

SELECT
  cr.from_currency,
  cr.to_currency,
  cr.conversion_type,
  cr.conversion_date,
  cr.conversion_rate,
  cr.last_updated_by,
  cr.last_update_date
FROM   gl_daily_rates cr
WHERE  cr.conversion_date >= TRUNC(SYSDATE) - 30
ORDER  BY cr.conversion_date DESC, cr.from_currency, cr.to_currency

A single read-only SELECT against Oracle Fusion Cloud's supported reporting surface. Column names and views can differ by release and by the roles your reporting account holds, so validate the result against a report you already trust before relying on it.

setupcurrencyfx

Recently changed lookup values

Lookup-type/value pairs updated in the last 90 days. Lookups often drive validation and posting behaviour.

Run it without the template cycle

QueryWell runs this and 81 other curated scripts against your own Fusion pod from one signed desktop app — grid, charts, profiling and hashed exports included. Perpetual licence, 14-day trial.

Start a free 14-day trial Get the free query pack by email