Asset additions in period
All assets capitalised in a given period across asset books.
Tables used
fa_additions_b fa_additions_tl fa_books
Bind parameters
Supply values for :start_date, :end_date when you run 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.
SELECT ad.asset_id, ad.asset_number, tl.description, ad.asset_category_id,
bk.book_type_code, bk.cost, bk.date_placed_in_service, ad.created_by
FROM fa_additions_b ad
JOIN fa_additions_tl tl ON tl.asset_id = ad.asset_id AND tl.language = USERENV('LANG')
JOIN fa_books bk ON bk.asset_id = ad.asset_id
WHERE bk.date_placed_in_service BETWEEN :start_date AND :end_date
AND bk.transaction_header_id_out IS NULL
ORDER BY bk.cost DESCA 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-assetscapex
More Fixed Assets queries
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.