PA Project Budget – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Report of Standard Project Budgets. This report does not include Financial Plan Budgets. In addition to the budget details, the report will also display the actuals matching the budget line datapoints. Note: Inclusion of actuals data requires Blitz Report Build Data later than 04-APR-2025 03:21:50

Report Parameters

Operating Unit, Project Number, Project Name, Budget Type, Budget Status, Latest Budget Version, Budget Version, Task Number, Task Name, Resource Alias, Period From, Period To, Budget Line Start Date, Budget Line End Date, Budget Line Active On Date, Show DFF Attributes, Show Actuals, Sort Precedence 1, Sort Precedence 2, Sort Precedence 3

Oracle EBS Tables Used

hr_all_organization_units_vl, pa_projects_all, pa_budget_versions, pa_budget_types, pa_budget_entry_methods, pa_resource_lists, pa_resource_assignments, pa_budget_lines, pa_tasks, pa_resource_list_members, mo_glob_org_access_tmp, dual

Report Categories

Enginatics

PA Project Budget Upload, PA Budget Upload, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, GL Account 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 Project Budget 04-Apr-2026 023352.xlsx
Blitz Report™ XML Import PA_Project_Budget.xml
Full SQL on Enginatics www.enginatics.com/reports/pa-project-budget/

PA Project Budget - Case Study & Technical Analysis

Executive Summary

The PA Project Budget report is a cornerstone of project financial management within Oracle Projects. It provides project managers and financial controllers with a detailed view of project budgets, enabling them to monitor planned spending against actual costs. By supporting multiple budget types (Cost, Revenue) and versions (Baselined, Current Working), this report ensures that organizations can maintain strict financial discipline over their project portfolios.

Business Challenge

Project-driven organizations often struggle with:

Solution

This SQL-based report solves these challenges by extracting comprehensive budget details directly from the Oracle Projects schema. It allows users to:

Technical Architecture

The report leverages the core Oracle Projects budget model, linking projects, tasks, and resource assignments to budget lines.

Key Tables & Views

| Table Name | Description | | :— | :— | | PA_PROJECTS_ALL | The master table for project definitions. | | PA_BUDGET_VERSIONS | Stores header information for each budget version (e.g., Version Number, Status). | | PA_BUDGET_TYPES | Defines the type of budget (e.g., Approved Cost, Approved Revenue). | | PA_RESOURCE_ASSIGNMENTS | Links budget amounts to specific resources and tasks. | | PA_BUDGET_LINES | Contains the periodic budget amounts (Raw Cost, Burdened Cost, Revenue) and dates. | | PA_TASKS | Provides the Work Breakdown Structure (WBS) hierarchy. |

Core Logic

  1. Project & Task Context: The query starts with PA_PROJECTS_ALL and joins to PA_TASKS to establish the WBS context.
  2. Budget Version Selection: It filters PA_BUDGET_VERSIONS based on the user’s selection (e.g., “Current Baselined” or specific version number).
  3. Resource Mapping: PA_RESOURCE_ASSIGNMENTS connects the budget version to the specific resources being budgeted.
  4. Line Detail: PA_BUDGET_LINES provides the granular period-by-period financial data.

FAQ

Q: Does this report show both Cost and Revenue budgets? A: Yes, the report can be filtered by Budget Type to show Cost, Revenue, or both.

Q: Can I see the “Original” budget vs the “Current” budget? A: Yes, the report parameters allow selection of specific budget versions or dynamic selection of the “Latest Baselined” version.

Q: How are “Actuals” handled in this report? A: The report includes logic to fetch actuals matching the budget line datapoints, provided the Blitz Report Build Data is up to date.

Q: Does it support multi-currency budgets? A: Yes, the underlying tables (PA_BUDGET_LINES) store amounts in transaction, project, and project functional currencies.

© 2026 Enginatics