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 143 AR 123 FA 138 CE 25 PO 116 INV 129 OM 89 MFG 214 COST 175 PA 131 HR 182 PAY 151 SYS 162

3,151 reports

DescriptionDownload
IGI Standing Charges: Transaction Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Standing Charges: Transaction Report Application: Public Sector Financials International Source: Standing Charges: Transaction Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIRRTRN_XML DB package: IGI_IGIRRTRN_XMLP_PKG
 BI Publisher XML
IGI Subledger Security: Allocation Status - draft
Application: Public Sector Financials International Source: Subledger Security: Allocation Status Report (XML) - Not Supported: Reserved For Future Use Short Name: IGISLSSA_XML DB package: IGI_IGISLSSA_XMLP_PKG
 BI Publisher XML
IGI Subledger Security: Consolidation - draft
Application: Public Sector Financials International Source: Subledger Security: Consolidation Report (XML) - Not Supported: Reserved For Future Use Short Name: IGISLSCG_XML DB package: IGI_IGISLSCG_XMLP_PKG
 BI Publisher XML
IGI Subledger Security: Group Status - draft
Application: Public Sector Financials International Source: Subledger Security: Group Status Report (XML) - Not Supported: Reserved For Future Use Short Name: IGISLSSG_XML DB package: IGI_IGISLSSG_XMLP_PKG
 BI Publisher XML
IGI Subledger Security: Grouped Secure Tables - draft
Application: Public Sector Financials International Source: Subledger Security: Grouped Secure Tables Report (XML) - Not Supported: Reserved For Future Use Short Name: IGISLSTL_XML DB package: IGI_IGISLSTL_XMLP_PKG
 BI Publisher XML
IGI Subledger Security: Object Status - draft
Application: Public Sector Financials International Source: Subledger Security: Object Status Report (XML) - Not Supported: Reserved For Future Use Short Name: IGISLSOS_XML DB package: IGI_IGISLSOS_XMLP_PKG
 BI Publisher XML
IGI Subledger Security: Secure Tables Status - draft
Application: Public Sector Financials International Source: Subledger Security: Secure Tables Status Report (XML) - Not Supported: Reserved For Future Use Short Name: IGISLSST_XML DB package: IGI_IGISLSST_XMLP_PKG
 BI Publisher XML
IGI Subledger Security: User Allocation Status - draft
Application: Public Sector Financials International Source: Subledger Security: User Allocation Status Report (XML) - Not Supported: Reserved For Future Use Short Name: IGISLSUA_XML DB package: IGI_IGISLSUA_XMLP_PKG
 BI Publisher XML
IGI UnBalanced Budget History Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: BUD: Budgeting: Unbalanced Budget History Report Application: Public Sector Financials International Source: Budgeting: UnBalanced Budget History Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIGBHRU_XML DB package: IGI_IGIGBHRU_XMLP_PKG
 BI Publisher XML
IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: BUD: Budgeting: Unbalanced Budget Journal Report Application: Public Sector Financials International Source: Budgeting: Unbalanced Budget Journal Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIGBJRU_XML DB package: IGI_IGIGBJRU_XMLP_PKG
 BI Publisher XML
INL Landed Cost Detail
Application: Oracle Landed Cost Management Source: Landed Cost Detail Report (XML) Short Name: INLLCCRP_XML DB package: INL_INLLCCRP_XMLP_PKG
 BI Publisher XML
INL Landed Cost Summary
Application: Oracle Landed Cost Management Source: Landed Cost Summary Report (XML) Short Name: INLSLCRP_XML DB package: INL_INLSLCRP_XMLP_PKG
 BI Publisher XML
INL Unaccounted Landed Costs for Full Returns
Application: Oracle Landed Cost Management Source: Unaccounted Landed Costs for Full Returns (XML) Short Name: INLRTSCP_XML DB package: INL_INLRTSCP_XMLP_PKG
 BI Publisher 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
ISG Healthcheck XML
Inventory Listing XML
Inventory MAD - Material account dist XML
Inventory mad XML
Item Material Account Distributions XML
Item listing XML
Item listing gw XML
Item_Forecast
Testing
 XML
Items list XML
Items with txns XML
JA Account Balance Export Exception
Application: Asia/Pacific Localizations Source: Account Balance Export Exception Report Short Name: JACNABER DB package:
 BI Publisher XML