Blitz Report™ Library

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

131 reports

DescriptionDownload
PA Capital Project Summary with Asset Detail
Detail project report that shows the project asset details, and combined project level costs breakdown, along with the project assets details from the Capital Summary
Projects Enginatics, R12 only XLS XML
PA Cost Audit
Project cost distribution lines transferred to GL showing DR/CR accounts, amounts, transfer status, and GL dates for audit and reconciliation purposes.
Projects Enginatics XLS XML
PA Expenditure Types
Listing of project expenditure types with their category, type class, unit of measure, and active dates.
Projects Enginatics XLS XML
PA Invoice Review
Project draft invoices with line details showing invoice amounts, approval and release status, customer, GL date, and expenditure type breakdown.
Projects Enginatics XLS XML
PA Project Asset Details
Capital project asset information showing CIP costs, capitalized amounts, FA asset numbers, estimated and actual in-service dates, and asset line transfer status.
Projects Enginatics XLS XML
PA Project Billing Status
Project billing overview showing revenue, billed and unbilled amounts, funding totals, and available funding for each project.
Projects Enginatics XLS XML
PA Project Budget
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
Projects Enginatics XLS XML
PA Project Expenditure Items with WIP and INV Detail
Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource, and inventory item information.
Projects Enginatics, R12 only XLS XML
PA Project Status Summary
Project-level financial overview showing actual costs, revenue, labor hours, and commitments for each project with manager and status information.
Projects Enginatics XLS XML
PA Project Subledger Detail by Expenditure Type
Cost distribution lines summarized by project, task, expenditure type, and GL account showing raw cost, burden cost, and total cost for transferred and accepted lines.
Projects Enginatics XLS XML
PA Supplier Invoice Audit
AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit.
Projects Enginatics, R12 only XLS XML
PA Task Schedule
Summary project report showing operating unit, project, task, scheduled start date, scheduled finish date, created by, and last updated by.
Projects Enginatics XLS XML
PA Transaction Sources Projects Enginatics XLS XML
PA Budget Upload
The PA Budget Upload supports the creation/update of standard project budgets. At this stage it does not support the creation/update of Financial Plan Budgets. The PA Budget Upload allows users to: - Create new working budgets. When creating a new working budget, any existing working budget for the specified Project and Budget Type will be overwritten. The upload allows the user to create a working budget either by entering the data directly into an empty upload excel file, or by copying a prior version of the budget and modifying this in the upload excel file. - Update existing…
full description
Projects Enginatics, Upload XML
PA Employee Activity By Organization
Labor hours summary by employee, project, and task showing total, billable, and non-billable hours with cost amounts for the expenditure organization.
Projects Enginatics XML
PA Event Upload
PA Event Upload =================== This upload can be used to create new Project Billing and Revenue Events against the Projects belonging to the Operating Units accessible to the current responsibility. If the Operating Unit parameter is specified, then the upload will be restricted to Projects within the specified Operating Unit only.
Projects Enginatics, Upload XML
PA Missing Timecards
Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor. Timecard Source Project Expenditures lists employees without a project expenditure for the week ending date. OTL Timecards lists employees without an OTL timecard whose period contains the week ending date, including employees who do not charge projects.
Projects Enginatics XML
PA Project Asset Upload
PA Project Asset Upload ====================== Create, update, or delete project assets and their task assignments for Oracle Projects capital projects, using the public API pa_project_assets_pub. Supported Actions: - Create / Update project asset (ESTIMATED or AS-BUILT types only — RETIREMENT_ADJUSTMENT is excluded) - Add / Delete asset-to-task assignment (top-task rollup or leaf-task) Row Structure (bundled parent-child): - One row per (asset, assignment) pair - Leave Assignment Task Number blank on a row to create/update just the asset header with no assignment - For multiple assignments…
full description
Projects Enginatics, Upload XML
PA Project Upload
PA Project Upload =================== Create and update Projects in Oracle Projects using the pa_project_pub API. Create Mode: - Select a Template to populate default values (project type, organization, billing setup, etc.) - Template-specific required fields (customer, organization, completion date, etc.) are validated in Excel before upload - Project Manager can differ from the template PM — the template PM is replaced post-creation - PM Product Code determines which external PM system owns the project (default: Primavera). Do NOT use Microsoft Project — it blocks date updates due to…
full description
Projects Enginatics, Upload XML
PA Revenue, Cost, Budgets by Resources
This Blitz Report is the implements the following standard oracle reports. - MGT: Task - Revenue, Cost, Budgets by Resources - MGT: Revenue, Cost, Budgets by Resources (Project Level) The 'Report Level' parameter determines if the report is run at the Project Level or Task Level Report Level Parameter: Project - equivalent to running the MGT: Revenue, Cost, Budgets by Resources (Project Level) report Task - equivalent to running the MGT: Task - Revenue, Cost, Budgets by Resources report The report has been extended to pull in additional datapoints as displayed in the Project Status…
full description
Projects Enginatics, R12 only XML
PA Revenue, Cost, Budgets by Work Breakdown Structure
This Blitz report implements the standard Oracle report: MGT: Revenue, Cost, Budgets by Work Breakdown Structure (XML) The 'Report Level' parameter determines if the report is run at the Project Level or Task Level Report Level Parameter: Project - will pull back revenue, costs and budgets accumulated at the project level Task - will pull back revenue, costs and budgets accumulated at the task level The report has been extended to pull in additional datapoints as displayed in the Project Status Inquiry Form. Application: Projects Source: MGT: Revenue, Cost, Budgets by Work Breakdown…
full description
Projects Enginatics, R12 only XML
PA Task Upload
PA Task Upload ====================== Create new tasks or update existing task attributes within Oracle Projects using APIs pa_project_pub.add_task and pa_project_pub.update_task. This upload does not create projects — it operates on tasks within existing projects. Supported Actions: - Create: Add new top-level tasks, child tasks under existing parents, or entire parent-child hierarchies - Update: Modify attributes of existing tasks (organization, manager, work type, flags, schedules, etc.) Report Parameters: - Upload Mode: 'Create' for new tasks only, or 'Create, Update' for both -…
full description
Projects Enginatics, Upload XML
PA Transaction Upload
PA Transaction Upload =================== This upload can be used to upload transactions from external cost collection systems into Oracle Projects. Transaction Import creates pre-approved expenditure items from transaction data entered in external cost collection systems. If the 'Operating Unit' and/or 'Transaction Source' parameters are specified, then the upload excel will be restricted to the specified Operating Unit and/or Transaction Source. If the 'Batch Name' parameter is specified, this will default as the Batch Name in the upload Excel. If the 'All Negative Expend Unmatched'…
full description
Projects Enginatics, Upload XML
PA Agreement Status By Customer
Application: Projects Source: MGT: Agreement Status By Customer (XML) Short Name: PAXAGAST_XML DB package: PA_PAXAGAST_XMLP_PKG
Projects BI Publisher XLS XML
PA Agreement Types
Application: Projects Source: IMP: Agreement Types (XML) Short Name: PAXRWAGT_XML DB package: PA_PAXRWAGT_XMLP_PKG
Projects BI Publisher XLS XML
PA AutoAccounting Lookup Sets
Application: Projects Source: IMP: AutoAccounting Lookup Sets (XML) Short Name: PAXAASVL_XML DB package: PA_PAXAASVL_XMLP_PKG
Projects BI Publisher XLS XML
PA Capital Project Summary
Imported from BI Publisher Description: Report for viewing capital project summary amounts Application: Projects Source: MGT: Capital Project Summary Report (XML) Short Name: PACRCAPS_XML DB package: PA_PACRCAPS_XMLP_PKG
Projects BI Publisher XLS XML
PA Class Categories and Codes
Application: Projects Source: IMP: Class Categories and Codes (XML) Short Name: PAXRWPCC_XML DB package: PA_PAXRWPCC_XMLP_PKG
Projects BI Publisher XLS XML
PA Credit Types
Application: Projects Source: IMP: Credit Types (XML) Short Name: PAXRWCTY_XML DB package: PA_PAXRWCTY_XMLP_PKG
Projects BI Publisher XLS XML
PA Event Types
Application: Projects Source: IMP: Event Types (XML) Short Name: PAXRWPET_XML DB package: PA_PAXRWPET_XMLP_PKG
Projects BI Publisher XLS XML
PA Expense Report Audit
Imported from BI Publisher Description: Expense Report Audit Report Application: Projects Source: AUD: Expense Report Audit Report (XML) Short Name: PAXAUERT_XML DB package: PA_PAXAUVIT_XMLP_PKG
Projects BI Publisher XLS XML
PA Generate Calendar Schedule for a Single Calendar
Imported from BI Publisher Description: Generate Calendar Schedule for a Single Calendar Application: Projects Source: PRC: Generate Calendar Schedule for a Single Calendar (XML) Short Name: PARGCALGS_XML DB package: PA_PARGCALG_XMLP_PKG
Projects BI Publisher XLS XML
PA Generate Capitalized Interest Transactions
Imported from BI Publisher Description: PRC: Generate Capitalized Interest Transactions Application: Projects Source: PRC: Generate Capitalized Interest Transactions (XML) Short Name: PACCINTG_XML DB package: PA_PACCINTG_XMLP_PKG
Projects BI Publisher XLS XML
PA Inactive Capital Projects
Application: Projects Source: MGT: Inactive Capital Projects Report (XML) Short Name: PACINTAR_XML DB package: PA_PACINTAR_XMLP_PKG
Projects BI Publisher XLS XML
PA Invoice Formats Listing
Application: Projects Source: IMP: Invoice Formats Listing (XML) Short Name: PAXRWDIF_XML DB package: PA_PAXRWDIF_XMLP_PKG
Projects BI Publisher XLS XML
PA Labor Cost Rates Listing
Application: Projects Source: IMP: Labor Cost Rates Listing (XML) Short Name: PAXRWLCR_XML DB package: PA_PAXRWLCR_XMLP_PKG
Projects BI Publisher XLS XML
PA Organization Hierarchy
Application: Projects Source: IMP: Organization Hierarchy (XML) Short Name: PAXRWDOH_XML DB package: PA_PAXRWDOH_XMLP_PKG
Projects BI Publisher XLS XML
PA Organization Listing
Application: Projects Source: IMP: Organization Listing (XML) Short Name: PAXPEORG_XML DB package: PA_PAXPEORG_XMLP_PKG
Projects BI Publisher XLS XML
PA PCO Report Data Template
Application: Projects Source: Short Name: PAPCOREP DB package:
Projects BI Publisher XLS XML
PA Project Contact Types
Application: Projects Source: IMP: Project Contact Types (XML) Short Name: PAXRWPCT_XML DB package: PA_PAXRWPCT_XMLP_PKG
Projects BI Publisher XLS XML
PA Project Customer Relationships
Application: Projects Source: IMP: Project Customer Relationships (XML) Short Name: PAXRWPCR_XML DB package: PA_PAXRWPCR_XMLP_PKG
Projects BI Publisher XLS XML
PA Project Manager Reporting Pack
Application: Projects Source: Project Manager Reporting Pack Short Name: PARPPROJMGR DB package:
Projects BI Publisher XLS XML
PA Project Roles
Application: Projects Source: IMP: Project Roles (XML) Short Name: PAXRWPRT_XML DB package: PA_PAXRWPRT_XMLP_PKG
Projects BI Publisher XLS XML
PA Project Statuses
Application: Projects Source: IMP: Project Statuses (XML) Short Name: PAXRWPJS_XML DB package: PA_PAXRWPJS_XMLP_PKG
Projects BI Publisher XLS XML
PA Project Subledger Summary
Imported from BI Publisher Description: AUD: Project Subledger: Summary Application: Projects Source: AUD: Project Subledger Summary (XML) Short Name: PAXMGSLS_XML DB package: PA_PAXMGSLS_XMLP_PKG
Projects BI Publisher XLS XML
PA Project Subledger: Detail by Expenditure Type
Imported from BI Publisher Description: AUD: Project Subledger: Detail by Expenditure Type: Shows the transactions in Oracle Projects for a GL account Expenditure Typewise across projects Application: Projects Source: AUD: Project Subledger: Detail by Expenditure Type (XML) Short Name: PAXMGSLE_XML DB package: PA_PAXMGSLD_XMLP_PKG
Projects BI Publisher XLS XML
PA Project Types
Application: Projects Source: IMP: Project Types (XML) Short Name: PAXRWPTY_XML DB package: PA_PAXRWPTY_XMLP_PKG
Projects BI Publisher XLS XML
PA Projects Periods
Application: Projects Source: IMP: Projects Periods (XML) Short Name: PAXRWPST_XML DB package: PA_PAXRWPST_XMLP_PKG
Projects BI Publisher XLS XML
PA Rebuild Timeline for a Single Resource
Imported from BI Publisher Description: Rebuild Timeline for a Single Resource Application: Projects Source: PRC: Rebuild Timeline for a Single Resource (XML) Short Name: PARLBLDGS_XML DB package: PA_PARLBLDG_XMLP_PKG
Projects BI Publisher XLS XML
PA Service Types
Application: Projects Source: IMP: Service Types (XML) Short Name: PAXRWPSV_XML DB package: PA_PAXRWPSV_XMLP_PKG
Projects BI Publisher XLS XML