Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

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).

Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162

Enginatics

23 reports

	Description
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
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
PA Expenditure Types	Listing of project expenditure types with their category, type class, unit of measure, and active dates.	Projects Enginatics
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
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
PA Project Billing Status	Project billing overview showing revenue, billed and unbilled amounts, funding totals, and available funding for each project.	Projects Enginatics
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
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
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
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
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
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
PA Transaction Sources		Projects Enginatics
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
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
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
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
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
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
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
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
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
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

Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

Also found in SQL, tables and columns