PA Supplier Invoice Audit – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Projects · all Projects reports

Overview

AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Operating Unit, Project, Vendor, GL Date From, GL Date To

Oracle EBS Tables Used

pa_cost_distribution_lines_all, pa_expenditure_items_all, pa_expenditures_all, pa_projects_all, pa_tasks, ap_invoices_all, ap_suppliers, gl_code_combinations_kfv, hr_all_organization_units_vl, mo_glob_org_access_tmp, dual

Report Categories

Enginatics, R12 only

PA Cost Audit, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, AP Expense Report Upload, PA Project Subledger Detail by Expenditure Type, AP Distribution Set Upload, AP Distribution Set Listing

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output PA Supplier Invoice Audit 04-Apr-2026 023352.xlsx
Blitz Report™ XML Import PA_Supplier_Invoice_Audit.xml
SQL Source PA Supplier Invoice Audit.sql
Full Report on Enginatics www.enginatics.com/reports/pa-supplier-invoice-audit/

Case Study & Technical Analysis: PA Supplier Invoice Audit

Executive Summary

The PA Supplier Invoice Audit report shows supplier invoices that have been charged to Oracle Projects, with the vendor, the invoice, the project and task, the cost distribution and the general ledger transfer details. It is written for project accounting teams, internal auditors and project controllers who must verify that supplier costs have been charged to the right project and task and transferred to the general ledger. Each row is a cost distribution line of type R, which is the Payables-originated cost, so the report traces a supplier invoice from Payables into project costing and on to the GL account. It sits in the Projects module and is restricted to R12.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. PA_COST_DISTRIBUTION_LINES_ALL joins to PA_EXPENDITURE_ITEMS_ALL on the expenditure item identifier.
  2. Expenditure items join to PA_EXPENDITURES_ALL, PA_PROJECTS_ALL and PA_TASKS on their identifiers.
  3. Expenditure items join to AP_INVOICES_ALL as an outer join on the document header identifier, which is the invoice identifier for supplier items.
  4. The invoice joins to AP_SUPPLIERS as an outer join on the vendor identifier.
  5. The distribution joins to GL_CODE_COMBINATIONS_KFV as an outer join on the debit code combination.
  6. The project’s operating unit is joined through HR_ALL_ORGANIZATION_UNITS_VL.
  7. Only distribution lines of type R, and expenditure items with the VI system linkage function, are returned.

Parameters & Filtering

The SQL text in the library does not reference these parameters by name, so the filters are applied by the report framework and not by predicates shown in the query.

Performance & Optimization

FAQ

Q: How do I see which supplier invoices were charged to a project in Oracle Projects? A: Run PA Supplier Invoice Audit and filter by project number. Each row shows the invoice number, vendor, task and cost.

Q: How can I check whether a supplier cost has transferred to the general ledger? A: Read the transfer status, transfer date and GL date columns for the distribution line.

Q: Which cost amounts does the report show? A: It shows the raw cost and burdened cost of each cost distribution line, along with the expenditure item quantity.

© Enginatics GmbH