Procurement volume by buyer (last 90 days)
Spend created per buyer / agent — useful for workload and concentration views.
Tables used
po_headers_all po_lines_all per_person_names_f
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 nm.full_name AS buyer_name, COUNT(DISTINCT ph.po_header_id) AS po_count,
SUM(pl.quantity * pl.unit_price) AS total_committed
FROM po_headers_all ph
JOIN po_lines_all pl ON pl.po_header_id = ph.po_header_id
JOIN per_person_names_f nm ON nm.person_id = ph.agent_id AND nm.name_type = 'GLOBAL' AND TRUNC(SYSDATE) BETWEEN nm.effective_start_date AND nm.effective_end_date
WHERE ph.creation_date >= SYSDATE - 90
GROUP BY nm.full_name
ORDER BY total_committed 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.
pobuyerworkload
More Procurement 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.