AR adjustments by user (last 90 days)
Who has been writing down receivables and by how much — useful for analyst review.
Tables used
ar_adjustments_all
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.
SELECT
adj.created_by,
COUNT(*) AS adjustment_count,
SUM(adj.amount) AS total_adjusted,
MIN(adj.creation_date) AS earliest,
MAX(adj.creation_date) AS latest
FROM ar_adjustments_all adj
WHERE adj.creation_date >= SYSDATE - 90
GROUP BY adj.created_by
ORDER BY total_adjusted 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.
aradjustmentswrite-off
More Accounts Receivable 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.