Free Fusion SQLFixed AssetsRead-only

Asset retirements last 12 months

Recently retired assets including gain/loss on disposal.

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

Tables used

fa_retirements fa_additions_b fa_additions_tl

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-fa-retirements

SELECT r.asset_id, ad.asset_number, tl.description, r.book_type_code, r.date_retired,
  r.cost_retired, r.proceeds_of_sale, r.gain_loss_amount, r.created_by
FROM fa_retirements r
JOIN fa_additions_b ad ON ad.asset_id = r.asset_id
JOIN fa_additions_tl tl ON tl.asset_id = r.asset_id AND tl.language = USERENV('LANG')
WHERE r.date_retired >= ADD_MONTHS(TRUNC(SYSDATE), -12)
ORDER BY r.date_retired 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.

fafixed-assetsretire

Asset additions in period

All assets capitalised in a given period across asset books.

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