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

75 reports

DescriptionDownload
BOM Item Where Used GUI
Description: Item Where Used GUI Report Provides equivalent functionality to the the following standard reports: - Item Where Used Report GUI Application: Bills of Material Source: Item Where Used Report GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG
Manufacturing Enginatics XML
BOM Routing Upload
Report: BOM Routing Upload This upload can be used to create and/or update existing manufacturing BOM Routings. - Create new Standard, Flow, and Lot Based (Network) Routings - Update or Delete existing Standard, Flow, and Lot Based (Network) Routings - Upload new Common Routing Assignments
Manufacturing Enginatics, Upload XML
BOM Standard Operations Upload
Report: BOM Standard Operations Upload This upload can be used to create and/or update BOM Standard Operations. Standard operations are reusable operation templates that routings can reference. The upload covers: - Standard operation header (code, type, line, department, attributes, EAM and OSFM extensions) - Primary resource assignments to the standard operation - Substitute (alternate) resource assignments - Descriptive flexfield attributes on the header and primary resources Each Excel row represents one resource of a standard operation. Header columns repeat across resource rows of the…
full description
Manufacturing Enginatics, R12 only, Upload XML
EAM Asset Activity Association Upload
EAM Asset Activity Association Upload ===================================== - Create new associations between an Activity item and an Asset Group, specific Asset Number (serial instance), or Rebuildable item. - Update existing association attributes (dates, priority, owning department, WIP class, DFF, etc.). - Deletion is not supported by the public API in v1. Prerequisites ============= - The Activity item (eam_item_type=2) must already exist in the maintenance organization. Use the INV Item Upload to create Activity items. - For Asset Group associations, the Asset Group (eam_item_type=1)…
full description
Manufacturing Enginatics, R12 only, Upload XML
EAM Asset Attribute Upload
Create and update Oracle Enterprise Asset Management asset attribute values, the attribute group values of an asset or rebuildable number. Attribute groups are assigned to an asset group (Enterprise Asset Management: Asset Groups, Attributes) and their values are entered per asset number in the Asset Attributes window. Each row uploads one attribute group of one asset number, so an asset with several attribute groups has one row per group. The attribute columns follow the flexfield segments of the selected attribute group: Attribute 1-20 hold the character segments, Number Attribute 1-10…
full description
Manufacturing Enginatics, Upload XML
EAM Asset Number Upload
Create and update Oracle Enterprise Asset Management asset numbers (maintenance assets). Parent Asset Number places the asset in the asset hierarchy; clearing it on an existing asset removes the parent. Parent Asset Serial Number and Parent Asset Id follow the parent asset number and are read only. An existing asset is identified by its Asset Id, so its Asset Number can be changed. Current Location Address lists the addresses of the TCA locations, as the Update Asset page does; an address that exists more than once carries the location id in brackets.
Manufacturing Enginatics, R12 only, Upload XML
EAM Failure Codes Upload
Create, update, and delete EAM failure codes, cause codes, and resolution codes. Upload Mode =========== Create ------ Opens an empty spreadsheet to define new codes. Create, Update -------------- Downloads existing codes for review and modification, and allows adding new rows. Code Type ========= Determines which of the three code tables is affected: - Failure Code (stored in eam_failure_codes) - Cause Code (stored in eam_cause_codes) - Resolution Code (stored in eam_resolution_codes) Codes are global - not scoped to any operating unit. Fields ====== - Code Type: Required.…
full description
Manufacturing Enginatics, R12 only, Upload XML
EAM Failure Sets Upload
EAM Failure Sets Upload ======================= Creates and updates Oracle EAM (Enterprise Asset Management) Failure Sets, along with their Asset-Group Item Associations and Failure/Cause/Resolution Combinations. One Set Name can own many child rows (Associations and Combinations). A SET row defines the header explicitly. For Create rows, the upload also creates the missing failure set header automatically from the first ASSOCIATION or COMBINATION row for that Set Name. Row Type -------- - SET: Creates or updates the failure set header (set_name, description, effective_end_date). -…
full description
Manufacturing Enginatics, R12 only, Upload XML
EAM PM Schedule Upload
EAM Preventive Maintenance Schedule Upload ========================================= Create or update Oracle EAM Preventive Maintenance schedule definitions, including: - PM Schedule header (asset or asset group, activity, schedule name, set name, type, rescheduling point, etc.) - Activity group (for Rule Based schedules: list of activities with interval multiples) - Scheduling rules: Day Interval, Runtime / Meter, and List Date rules - Optional Last Service info (per meter) Row Model ========= Each spreadsheet row can contain PM header values plus any populated child-object columns.…
full description
Manufacturing Enginatics, R12 only, Upload XML
EAM PM Schedule Upload 11i
EAM Preventive Maintenance Schedule Upload ========================================= Create or update Oracle EAM Preventive Maintenance schedule definitions, including: - PM Schedule header (asset or asset group, activity, schedule name, set name, type, rescheduling point, etc.) - Activity group (for Rule Based schedules: list of activities with interval multiples) - Scheduling rules: Day Interval, Runtime / Meter, and List Date rules - Optional Last Service info (per meter) Row Model ========= Each spreadsheet row can contain PM header values plus any populated child-object columns.…
full description
Manufacturing Enginatics, Upload XML
EAM Work Orders 11i
Enterprise asset management work orders including asset and cost information
Manufacturing Enginatics XML
MRP Master Schedule Upload
MRP Master Schedule Upload ========================== - Create new MDS/MPS schedule entries. - Create and Update existing schedule entries. Each row stages one schedule entry into the MRP schedule interface (mrp_schedule_interface, process_status=2) for an existing schedule designator (MDS or MPS). The staged entries are loaded into the master schedule (mrp_schedule_dates) asynchronously by the customer's MRP Planning Manager. Upload Modes ============ Create - opens an empty spreadsheet to enter new schedule entries against any accessible schedule designator. Create and Update - downloads…
full description
Manufacturing Enginatics, Upload XML
MRP Sourcing Rule Assignment Upload
MRP Sourcing Rule Assignment Upload ============================= - Upload new Assignment Sets and Sourcing Rule Assignments - Update Existing Assignment Sets and Sourcing Rule Assignments Notes: If an Assignment Organization is specified, then this determines the selecatable items. If an Assignment Organization is not specified, then the Master Organization determines the selectable Items. The selectable Assignment Organizations is not restricted by the Master Organization. This is the same logic as used in the Sourcing Assignments form
Manufacturing Enginatics, Upload XML
MRP Sourcing Rule Upload
MRP Sourcing Rule Upload ==================== - Upload new Sourcing Rules - Update Existing Sourcing Rules
Manufacturing Enginatics, Upload XML
OPM Formula Upload
OPM Formula Upload ================== Create or update Oracle Process Manufacturing (OPM / GMD) Formulas via the public API GMD_FORMULA_PUB / GMD_FORMULA_DETAIL_PUB. Row model ========= One spreadsheet row per formula LINE. The header columns (Organization Code, Formula, Formula Version, Description, Class, Owner, Header Scale Type, Status, header attributes) repeat on every line of the same formula. Each line carries its Line Type (Ingredient / Product / By-Product) plus its item, quantity, UOM, scale, and line attributes. Rows of the same formula (Organization Code + Formula + Formula…
full description
Manufacturing Enginatics, R12 only, Upload XML
OPM Recipe Upload Manufacturing Enginatics, R12 only, Upload XML
OPM Routing Upload
OPM Routing Upload ================== Create or update Oracle Process Manufacturing (OPM / GMD) Routings via the public API GMD_ROUTINGS_PUB / GMD_ROUTING_STEPS_PUB. Row model ========= One spreadsheet row per routing STEP. The header columns (Organization Code, Routing, Routing Version, Description, Class, UOM, dates, owner, header attributes) repeat on every step of the same routing. Each step carries its Step No, Operation (No + Version), Step Quantity, Release Type, and step attributes. Rows of the same routing (Organization Code + Routing + Routing Version) must be contiguous. Every…
full description
Manufacturing Enginatics, R12 only, 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.
Manufacturing 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
Manufacturing 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
Manufacturing 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
Manufacturing 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
Manufacturing 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
Manufacturing 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
Manufacturing 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
Manufacturing Enginatics, R12 only XML