Free Fusion SQLSetup & ConfigRead-only

Recently changed lookup values

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

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

Tables used

fnd_lookup_values_vl

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-lookups-changed

SELECT l.lookup_type, l.lookup_code, l.meaning, l.enabled_flag, l.start_date_active, l.end_date_active, l.last_updated_by, l.last_update_date
FROM fnd_lookup_values_vl l
WHERE l.last_update_date >= SYSDATE - 90
ORDER BY l.last_update_date DESC

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.

setuplookupsconfig

Daily currency conversion rates loaded

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

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