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

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

130 reports

DescriptionDownload
INV Subinventory quantities
Imported from BI Publisher Description: Subinventory quantities report Application: Inventory Source: Subinventory quantities report (XML) Short Name: INVIRSIQ_XML DB package: INV_INVIRSIQ_XMLP_PKG
 Inventory BI Publisher XLS XML
INV Transaction source type summary
Imported from BI Publisher Description: Transaction source type summary Application: Inventory Source: Transaction source type summary (XML) Short Name: INVTRSTS_XML DB package: INV_INVTRSTS_XMLP_PKG
 Inventory BI Publisher XLS XML
INV Unit of measure listing
Imported from BI Publisher Description: Unit of measure listing Application: Inventory Source: Unit of measure listing (XML) Short Name: INVSRUOM_XML DB package: INV_INVSRUOM_XMLP_PKG
 Inventory BI Publisher XLS XML
INV Vendor lot trace
Imported from BI Publisher Description: Vendor lot trace report Application: Inventory Source: Vendor lot trace report (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG
 Inventory BI Publisher XLS XML
INV Consigned Return Transactions
Imported from BI Publisher Description: Inventory Consigned Return Transactions Report Application: Inventory Source: Consigned Return Transactions Report (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG
 Inventory BI Publisher XML
INV Expired lots
Imported from BI Publisher Description: Expired lots report Application: Inventory Source: Expired lots report (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG
 Inventory BI Publisher XML
INV Inactive items (1)
Imported from Concurrent Program Application: Inventory Source: Inactive items report Short Name: INVIRSLO
 Inventory Concurrent Program XML
INV Inactive items (2)
Imported from BI Publisher Description: Inactive items report Application: Inventory Source: Inactive items report (XML) Short Name: INVIRSLO_XML DB package: INV_INVIRSLO_XMLP_PKG
 Inventory BI Publisher XML
INV Inactive items (3)
Imported from BI Publisher Description: Inactive items report Application: Inventory Source: Inactive items report (XML) Short Name: INVIRSLO_XML DB package: INV_INVIRSLO_XMLP_PKG
 Inventory BI Publisher XML
INV Inter-organization shipping information listing
Imported from BI Publisher Description: Inter-organization shipping information listing Application: Inventory Source: Inter-organization shipping information listing (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG
 Inventory BI Publisher XML
INV Intercompany Transaction Flows
Inventory Intercompany Transaction Flows Setup
 Inventory XML
INV Intercompany by AP Invoice Number Diagnostics Inventory XML
INV Item Attributes Inventory XML
INV Item Organization Assignment
Imported from Concurrent Program Application: Inventory Source: Item Organization Assignment Short Name: INVITEMORG_ASSIGN
 Inventory Concurrent Program XML
INV Item cross-references listing
Imported from BI Publisher Description: Item cross-references listing Application: Inventory Source: Item cross-references listing (XML) Short Name: INVIRXRF_XML DB package: INV_INVIRXRF_XMLP_PKG
 Inventory BI Publisher XML
INV Item relationships listing
Imported from BI Publisher Description: Item relationships listing Application: Inventory Source: Item relationships listing (XML) Short Name: INVIRRIT_XML DB package: INV_INVIRRIT_XMLP_PKG
 Inventory BI Publisher XML
INV Item-subinventory
Imported from BI Publisher Description: Item-subinventory report Application: Inventory Source: Item-subinventory report (XML) Short Name: INVSRISA_XML DB package: INV_INVSRISA_XMLP_PKG
 Inventory BI Publisher XML
INV Lot Inventory
Application: Inventory Source: Lot Inventory Report Short Name: INVLOTINV DB package:
 Inventory XML
INV MTL TXNS Errors
Material Transactions details with account string
 Inventory XML
INV Mass Lot Attributes Sync
Imported from BI Publisher Description: Lot attributes update report Application: Inventory Source: Mass Lot Attributes Sync Short Name: INVLTATT_XML DB package: INV_INVLTATT_XMLP_PKG
 Inventory BI Publisher XML
INV Material Status Where-Used
Application: Inventory Source: Material Status Where-Used Report (XML) Short Name: INVMSWHU_XML DB package: INV_INVMSWHU_XMLP_PKG
 Inventory BI Publisher XML
INV Material Transactions2
Detail report of Inventory transactions with item, primary qty, secondary qty, transaction type, transaction ID and total transaction qty
 Inventory XML
INV Min-max planning
Imported from BI Publisher Description: Min-max planning report Application: Inventory Source: Min-max planning report (XML) Short Name: INVISMMX_XML DB package: INV_INVISMMX_XMLP_PKG
 Inventory BI Publisher XML
INV Movement Statistics Exception
Application: Inventory Source: Movement Statistics Exception Report (XML) Short Name: INVMVTEX_XML DB package: INV_INVMVTEX_XMLP_PKG
 Inventory BI Publisher XML
INV Organization Hierarchy Exceptions
Application: Inventory Source: Organization Hierarchy Exceptions Report (XML) Short Name: INVORGES_XML DB package: INV_INVORGES_XMLP_PKG
 Inventory BI Publisher XML
INV PAR Replenishment Count Worksheet
Imported from BI Publisher Description: PAR Replenishment Count Worksheet Application: Inventory Source: PAR Replenishment Count Worksheet (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG
 Inventory BI Publisher XML
INV Period close value summary
Imported from BI Publisher Description: Period close value summary Application: Inventory Source: Period close value summary (XML) Short Name: INVTRCLS_XML DB package: INV_INVTRCLS_XMLP_PKG
 Inventory BI Publisher XML
INV Physical inventory missing tag listing
Imported from BI Publisher Description: Physical inventory missing tag listing Application: Inventory Source: Physical inventory missing tag listing (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG
 Inventory BI Publisher XML
INV Print Kanban Cards
Imported from BI Publisher Description: Print Kanban Cards Application: Inventory Source: Print Kanban Cards (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG
 Inventory BI Publisher XML
INV Shortages Summary
Imported from BI Publisher Description: Shortages Summary report Application: Inventory Source: Shortages Summary report (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG
 Inventory BI Publisher XML