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

Enginatics

PA Supplier Invoice Audit, WIP Account Distribution, PA Project Subledger Detail by Expenditure Type, PA Project Expenditure Items with WIP and INV Detail, PA Employee Activity By Organization, CAC Receiving Expense Value (Period-End), GL Account Analysis, GL Account Distribution Analysis

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/

© 2026 Enginatics