| layout | default |
|---|---|
| title | PA Cost Audit | Oracle EBS SQL Report |
| description | Project cost distribution lines transferred to GL showing DR/CR accounts, amounts, transfer status, and GL dates for audit and reconciliation purposes. |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Cost, Audit, pa_cost_distribution_lines_all, pa_expenditure_items_all, pa_expenditures_all |
| permalink | /PA%20Cost%20Audit/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Project cost distribution lines transferred to GL showing DR/CR accounts, amounts, transfer status, and GL dates for audit and reconciliation purposes.
Operating Unit, Project, GL Date From, GL Date To, Period Name
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
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.
| 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/ |
- 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