PA Cost Audit – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Project cost distribution lines transferred to GL showing DR/CR accounts, amounts, transfer status, and GL dates for audit and reconciliation purposes.
Report Parameters
Operating Unit, Project, GL Date From, GL Date To, Period Name
Oracle EBS Tables Used
pa_cost_distribution_lines_all, pa_expenditure_items_all, pa_expenditures_all, pa_projects_all, pa_tasks, gl_code_combinations_kfv, hr_all_organization_units_vl, per_people_x, mo_glob_org_access_tmp, dual
Report Categories
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | PA Cost Audit 23-Mar-2026 121933.xlsx |
| Blitz Report™ XML Import | PA_Cost_Audit.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/pa-cost-audit/ |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics