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

835 reports

DescriptionDownload
PER Person Extra Information Upload 11i
Upload to create and update Person Extra Information Types (EITs) within Oracle HRMS - the People form > Others > Extra Information > Extra Person Information window. Scope: - Generic upload covering all person extra information types. The Information Type parameter/column lists every enabled context of the Extra Person Info DDF flexfield (titled Extra Person Information), which holds the registered EIT types. - The segment values are loaded as raw Information 1..30 columns (pei_information1..30), matching the order of the information type's flexfield segments. - Create new person extra…
full description
Enginatics, Upload XML
PER Person Upload
Upload to create and update people as in the People form (Combined Person and Assignment form, People window): employees, contingent workers and applicants, their personal details, Further Person Information and Additional Personal Details flexfields. A new person is created with hr_employee_api, hr_contingent_worker_api or hr_applicant_api depending on the system type of the Person Type. The Latest Start Date is the hire, placement or application date, and the API creates the default primary assignment in the business group. Use the PER Person Assignment Upload for the assignment…
full description
Enginatics, R12 only, Upload XML
PER Terminations and Separations
Terminated employees within a specified date range, showing termination date, leaving reason, length of service, last organization, job, position, grade, and supervisor. Useful for turnover analysis and exit tracking.
Enginatics XML
PN Billing/Payment Term Upload
Property Management - Billing and Payment Terms Upload
Enginatics, R12 only, Upload XML
PN GL Reconciliation
Application: Property Manager Report: PN GL Reconciliation
Enginatics, R12 only XML
PN Generate Lease Analysis
Application: Property Manager Source: Generate Lease Analysis Report Short Name: PNLAR_XML DB package: XXEN_PN
Enginatics, R12 only XML
PN Generate Lease Details
Application: Property Manager Source: Generate Lease Details Report Short Name: PNGLDR_XML DB package: XXEN_PN
Enginatics, R12 only XML
PN Generate Portfolio Detail
Application: Property Manager Source: Generate Portfolio Detail Report Short Name: PNGPDR_XML DB package: XXEN_PN
Enginatics, R12 only XML
PN Generate Portfolio Summary
Application: Property Manager Source: Generate Portfolio Summary Report Short Name: PNGPSR_XML DB package: XXEN_PN
Enginatics, R12 only XML
PO Acceptance Upload
This upload allows users to create new PO Acceptances (Acknowledgments)
Enginatics, Upload XML
PO Approved Supplier List Upload
This upload supports the creation and update of Approved Supplier Lists (ASL) in Oracle Purchasing. The upload supports creation/update/deletion of the following Approved Supplier List entities: - Approved Supplier Lists (Global and Local) - Approved Supplier List Attributes. Including Local (Using Organization specific) attributes against a global ASL. - Source Documents - Authorizations - Supplier Capacities - Supplier Tolerances Notes: - You cannot delete Manufacturer ASLs using this upload. There is a restriction in the standard Oracle API used by this upload that prevents this. - When…
full description
Enginatics, R12 only, Upload XML
PO Procure to Pay Tracker
One row per purchase order shipment, and per requisition line not yet on a purchase order, with the date of each step from requisition to payment and the accounting and GL posting of the invoice. Requisition columns are those of the first requisition line placed on the shipment. Invoice columns are those of the first invoice matched to the shipment; Invoiced Amount sums its matched item lines. Validation Status reads as in the invoice workbench, Hold Name lists the invoice's unreleased holds, and Amount Remaining is shown on the invoice's first row only, so it can be summed. Paid Date is the…
full description
Enginatics, R12 only XML
PO Purchasing Document Upload
Upload to create and update purchase documents The buyer of an existing standard purchase order can be changed. An approved order then requires reapproval, which the upload submits with the new buyer as preparer.
Enginatics, Upload XML
PO Receipts/Deliveries Discrepancy
PO Receipts/Deliveries Discrepancy highlights, at purchase order line and release level, differences between the quantities and amounts received into receiving (transaction type RECEIVE) and delivered to their final destination (DELIVER), including the impact of any CORRECT transactions applied to either side. Quantity Received and Quantity Delivered show the original transaction quantities, Quantity Corrected Receipt and Quantity Corrected Delivery the net correction impact, and Total Quantity Received and Total Quantity Delivered the corrected totals. Quantity Variance and Cost Variance…
full description
Enginatics, R12 only XML
PO Receiving Transaction Upload
PO Receiving Transaction Upload ================================ Create receiving transactions (receipts) against approved standard purchase orders. Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can manually enter PO receiving details. Create, Update -------------- Downloads open PO shipment lines with quantities available to receive for the selected organization. The user fills in the Quantity and Transaction Date columns for each line to receive, then uploads. Prerequisites ============= - PO must be approved and not cancelled or closed. - PO shipment…
full description
Enginatics, Upload XML
PO Requisition Template Upload
PO Requisition Template Upload ================================ The purpose of the PO Requisition Template Upload is to allow for: - the creation of new Requisition Templates (Create Mode). - the update of existing Requisition Templates (Update Mode). Update includes the update to existing template and template lines, the creation of new template lines against an existing template, and the deletion of template lines from an existing template. As far as feasible, the upload provides the user with the same functionality available in the ‘Requisition Template’ Form. (Purchasing: + Setup –…
full description
Enginatics, Upload XML
PO Requisition Upload 11i
Upload to create and update requisitions. In the generated Excel, the user can amend the following columns for an existing requisition. - Header Description - Quantity - Unit Price - Need By Date - Reference Number - Supplier Item - Buyer - Note To Buyer - Currency - Conversion Type - Conversion Rate - Conversion Date Additionally, the user can create a requisition by entering the below required fields. - Line Type - Source Type - Item - Item Description - Category - Unit of Measure - Quantity - Need By Date - Destination Type - Deliver To Requestor - Destination…
full description
Enginatics, Upload XML
PPF_WP3_OM_DETAILS
Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information.
Enginatics XML
PSA Budgetary Control Transactions
Imported from Concurrent Program Description: Budgetary Control Results Report Program Application: Public Sector Financials Source: Budgetary Control Results Report Short Name: PSABCRRP DB package: XXEN_PSA The Expand Amounts Yes/No Parameter determines whether or not the Budget, Encumbrances, Expenditures, and Funds Available Amounts are displayed on the same excel row (Expand=No) or are split into separate excel rows (Expand=Yes) in the generated excel. The following templates are provided with this report: Budgetary Control Transactions Pivot =========================== Corresponds to…
full description
Enginatics, R12 only XML
QA Collection Element Upload
Upload to create, update, or delete Quality Collection Elements (QA_CHARS). This upload manages user-defined collection elements including: - Element name, type, datatype, prompt, display length - Mandatory/Enabled flags - UOM, default value, data entry hint, SQL validation string - Sequence configuration (for Sequence datatype elements) Note: Specification limits, values, and actions are not managed by this upload. Datatype cannot be changed after initial creation.
Enginatics, Upload XML
QA Collection Plan Upload
Upload to create, update, or delete Quality Collection Plans and all child entities. This upload manages: - Collection Plan headers (name, type, dates, multirow flag) - Plan Transactions (transaction assignments, mandatory/background flags) - Collection Triggers (trigger conditions per transaction) - Plan Elements (collection element assignments, prompts, flags) - Element Values (value lookups per element) - Action Triggers (trigger sequences and conditions per element) - Actions (action assignments per trigger, including assign type, assigned element, alert action set and action, status…
full description
Enginatics, Upload XML
QA Plan Relationship Upload
Upload to create, update, or delete Quality Collection Plan parent-child relationships using the standard Oracle API qa_ss_parent_child_pkg. This upload manages: - Parent-Child Plan Relationships (QA_PC_PLAN_RELATIONSHIP) - Element Relationships between parent and child plans (QA_PC_ELEMENT_RELATIONSHIP) - Criteria for automatic child record creation (QA_PC_CRITERIA) Entry Modes: - Immediate: Child data entered immediately after parent record - Delayed: Child records entered manually later - Automatic: Child records auto-created when parent matches criteria - History: Child records…
full description
Enginatics, Upload XML
QP GSA Pricing Upload
This upload supports the creation and update of GSA Pricing Setup in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within a GSA Pricing List: - GSA Lists (created as a Modifier List) - GSA List Qualifiers (created as a Modifier List Qualifier) - GSA List Lines (created as Modifier Lines) Notes: When downloading existing GSA Lists into the upload excel; the List level Qualifiers and the List Lines will be downloaded into separate rows in the excel. This is to minimize the duplication of data in the excel. However: When entering List…
full description
Enginatics, Upload XML
QP Modifier Upload
This upload supports the creation and update of Modifiers in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within a Modifier List: - Modifier List Qualifiers - Modifier List Limits - Modifier Lines - Modifier Line Price Breaks. To enter the Modifier Price Breaks in the upload, repeat the Modifier Price Break Header Line and enter/adjust the Price Break Columns for each Price Break. - Modifier Line Additional Buy Items. - Modifier Line Get Items - Modifier Line Pricing Attributes - Modifier Line Qualifiers - Modifier Line Limits Notes: When…
full description
Enginatics, Upload XML
QP Price List Upload
This upload supports the creation and update of Standard Price Lists in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within the Price List: - Price List Lines 'End Date Matching List Lines?' When creating new Price List Lines, the upload can automatically end date any existing matching active price list line by setting the report parameter 'End Date Matching List Lines?' to Yes. Set this parameter to Yes to automatically end date any active matching price list line on upload. Any price list lines downloaded when this parameter is set to…
full description
Enginatics, Upload XML
QP Qualifier Group Upload
This upload supports the creation and update of Qualifier Groups in Oracle Advanced Pricing.
Enginatics, Upload XML
WF Notifications Enginatics, R12 only XML
WIP Job Upload
Upload to create and update WIP Discrete Jobs (Standard and Non-Standard) including operations, resources, and material requirements (components). Multiple inventory organizations can be combined in one upload file; the upload submits a separate WIP Mass Load run per organization. Job headers support all standard fields including assembly, class code, status, quantities, dates, scheduling, BOM/routing references (non-standard jobs), completion subinventory/locator, schedule group, line, project/task, and descriptive flexfield attributes. Operations, resources, and material requirements…
full description
Enginatics, Upload XML
WIP Material Transaction Upload
Issues components to, and returns components from, WIP work orders. The download returns one row per component requirement of the selected work orders, with the operation, department, supply subinventory and locator already filled in, and the required, issued and still open quantities shown. Enter a Transaction Type and a Quantity on the rows you want to transact and leave the rest blank. Quantity is always entered as a positive number; the Transaction Type decides the direction. Discrete jobs, lot based jobs and maintenance work orders are supported. Repetitive schedules are not. Rows…
full description
Enginatics, R12 only, Upload XML
WIP Move Transactions 11i
WIP move transactions of discrete jobs, lot based jobs, repetitive schedules and flow schedules, one row per transaction, as shown in the View Move Transactions form. The report covers the data of the Oracle standard Move Transaction Report (WIPTSMOV): from and to operation, department and intraoperation step, transaction and primary quantity, reason and reference, over-completion and scrap account. A repetitive move is shown once per repetitive schedule it was allocated to, with the schedule's first unit start date and the allocated quantity. Quantity is in the unit of measure the…
full description
Enginatics XML
WIP Value
Application: Work in Process Description: WIP Value Report This report will display Period To Date (PTD) and Cumulative To Date (CTD) WIP costs/variances for the selected period. The raw data (without template) provides a breakdown of these values by WIP Cost Type, Class, Discrete Job/Repetitive Schedule, Assembly, Element/Variance GL Account, and Period in which the cost is incurred/relieved. Templates are provided to detail or summarize the costs as followed: Applicable Templates: Pivot: WIP Value by Cost Type, Class - WIP Value Summary by Cost Type, Class with Drill Down to WIP Job…
full description
Enginatics XML
WIP Value Summary
Report to get the WIP and Material accounting distributions, by WIP job,period, Org . It displays detailed information from both sources WIP and Material Transactions Parameters: =========== Period: To pull the transactions based on specific inventory period ( transaction_date).(mandatory) Source: enter the source "WIP","Material" or "Both" you wish to report (mandatory). Category Set 1: any item category you wish, typically the Cost or Product Line category set (optional). Category Set 2: any item category you wish, typically the Inventory category set (optional). Category Set 3: any…
full description
Enginatics, R12 only XML
WSH Container Items Upload
Creates, updates and deletes container-item relationships - the Container-Item Relationships form (Shipping > Setup > Container Load Details). A relationship states the maximum quantity of a load item that fits into a container item in one inventory organization; auto-pack uses the load item's preferred container. Setting Preferred Flag to Yes removes the flag from the load item's current preferred container, as the form does after asking, and the Message names that container. When several rows of one file make different containers preferred for the same load item, the last row…
full description
Enginatics, Upload XML
WSH Pick Confirm Upload
WSH Pick Confirm Upload ======================= Confirms released sales order pick tasks in bulk from Excel: the picked quantity, the subinventory, locator and lot actually picked, the staging location and, in WMS enabled organizations, the LPN the material was packed into. Download the released to warehouse lines of an organization, optionally restricted to an order, delivery, trip, move order (pick slip), customer or item. One row is created per pick allocation, and per allocated lot for lot controlled items. Overwrite the pre-filled allocation where the pick differs, enter the LPN and…
full description
Enginatics, R12 only, Upload XML
ZX US Sales Tax
Imported from Concurrent Program Description: Sales Tax Report for use in U.S Application: E-Business Tax Source: U.S. Sales Tax Report Short Name: ZXXSTR The State, County and City columns are the tax jurisdiction the tax was determined for, which is the transaction ship to site falling back to the bill to site. The State Low and State High parameters filter on that same jurisdiction. The Ship To and Bill To address columns are the transaction sites themselves, so they can differ from those three. Invoice Freight Amount follows Invoice Lines Amount and Invoice Tax Amount: on an invoice or…
full description
Enginatics, R12 only XML