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

136 reports

DescriptionDownload
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
Enginatics, Upload XML
PER Location Upload
Upload to create, update, and delete HR Locations. Supports all country-specific address styles with address field validation. Includes site flags (Ship-To, Bill-To, Receiving, Office, Internal) with autocorrection for Ship-To and Receiving flags based on the Ship-To Location relationship. Includes the Descriptive Flexfield attributes with validation. Business group security restricts downloaded locations to the user's current business group plus global locations. New locations can optionally be made local by assigning the location to the user's current business group. If not assigned to…
full description
Enginatics, Upload XML
PER Organization Upload
Upload to create and update organizations, organization classifications, and organization information types within Oracle HRMS. Scope: - Create new organizations, assign classifications and information types, and specify the information type attributes - Update existing organization data, classifications (enable/disable), and the information type attributes - Supports all organization classification types: Business Groups (excluding creation of new Business Groups), HR Organization, Operating Unit, GRE/Legal Entity, Company Cost Center, Inventory Organization, etc. - Supports creation/update…
full description
Enginatics, Upload XML
PER Payroll Element Entry Upload
PER Payroll Element Entry Upload ================== Use this upload to upload new or update existing PER Payroll Element Entries, or to enter adjustment entries.
Enginatics, Upload XML
PER Person Assignment Upload
Upload to create and update employee assignments as in the Assignment window of the People form: organization, job, position, grade, payroll, location, status, categories, supervisor, probation and notice periods, standard conditions, statutory information, salary basis, people group and the Additional Assignment Details flexfield. Changes are made as of the Effective Date. When Datetrack Mode is blank, the assignment is corrected if the Effective Date is its start date, and otherwise a change is inserted from the Effective Date (Update, or Update - Insert when later changes exist). A new…
full description
Enginatics, R12 only, Upload XML
PER Person Extra Information Upload
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 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
PN Billing/Payment Term Upload
Property Management - Billing and Payment Terms Upload
Enginatics, R12 only, Upload 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 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 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
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
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
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
Ashish: GL Journal Upload
GL Journal Upload Templates are provided for the following Journal Types - Functional Actuals - Foreign Actuals - Budget Journals - Encumbrance Journals Submit for Approval --------------------------- Imported Journals requiring approval can be submitted for approval after import if they are eligble. Submit Journal Post --------------------------- Imported Journals can be submitted for immediate posting after import if they are eligible. In order to submit journals for posting, the current responsibility must have access to post journals.
Upload XML
Ashish: INV Physical Inventory Upload
This upload supports the creation of new Physical Inventories and the update of existing Physical Inventories that have not yet been frozen. The upload supports the specification of the subinventories to be included in the Physical Inventory. When updating an existing Physical Inventory, the Delete Subinventory upload column allows for individual subinventories to be removed from the Physical Inventory subinventory list. Replace Existing Subinventories ========================== When the Replace Existing Subinventories report parameter is set to Yes, the existing physical inventory…
full description
Upload XML
COPY OF: AP Invoice Upload
AP Invoice Upload
Upload XML
COPY OF: AP Supplier Upload
This upload can be used to create and/or update Suppliers, Supplier Sites, Supplier Bank Accounts, and Supplier Contacts
Upload XML
EC: INV Item Upload
INV Inventory Item Upload ====================== This upload can be used to create and update Inventory Items. It supports creation of Inventory Items: - by manually entering the Item details. - from a master row, with optional semicolon-separated child organization assignments - from an item template (Copy from Template) - from an existing item in the same Organization (Copy from Item) It supports update of existing Inventory Items either by: - update the details of an existing inventory items by downloading the items to be updated. Use the report parameters to select and download the…
full description
Upload XML
Ferrotec Work Order Creation Upload Process Upload XML
MDS TEST AP Supplier Upload
This upload can be used to create and/or update Suppliers, Supplier Sites, Supplier Bank Accounts, and Supplier Contacts
Upload XML
MRP Item Forecast Upload - Training
MRP Item Forecast Upload ================================ - Create New Item Forecast Entries. - Update Existing Item Forecast Entries. - Delete Existing Item Forecast Entries (Delete by setting the Forecast Quantity = 0). Prerequisites/Restrictions ========================== - Forecast Designators must be defined. - Item Forecasts can only be uploaded to a Forecast, not a Forecast Set. Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can enter new Forecast Entries against any accessible Forecast. Use the Organization Code, Forecast Set, Forecast Name…
full description
Training Purposes, Upload XML
SSS AR IC to PA Transaction Upload
Extracts billing transactions from an internal supplier AR invoice for an internal customer then uploads as expenditure items to the internal customer project
Upload XML
TNPL Demo: Blitz Upload Example (API)
Example upload for TNPL to create new uploads using an API.
Upload XML