Active projects with cost to date
Active projects with actual raw and burdened cost booked to date (from project costing). Flags high-cost active projects for PMO review.
Tables used
pjf_projects_all_b pjf_projects_all_tl pjc_exp_items_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 p.project_id, p.segment1 AS project_number, tl.name AS project_name, p.project_status_code,
ai.actual_raw_cost, ai.actual_burdened_cost
FROM pjf_projects_all_b p
JOIN pjf_projects_all_tl tl ON tl.project_id = p.project_id AND tl.language = USERENV('LANG')
JOIN (SELECT project_id, SUM(projfunc_raw_cost) AS actual_raw_cost, SUM(projfunc_burdened_cost) AS actual_burdened_cost
FROM pjc_exp_items_all GROUP BY project_id) ai ON ai.project_id = p.project_id
WHERE p.project_status_code IN ('APPROVED','OPEN','ACTIVE')
ORDER BY ai.actual_burdened_cost DESC NULLS LASTA 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.
projectscost
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.