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
SSP ShPP Adoption Element Results
Imported from BI Publisher Application: SSP Source: ShPP Adoption Element Results(XML) Short Name: SSPSHPAR DB package: SSP_SHARED_ADOPTION_RESULTS
 BI Publisher XML
SSP ShPP Birth Element Results
Imported from BI Publisher Application: SSP Source: ShPP Birth Element Results(XML) Short Name: SSPSHPBR DB package: SSP_SHARED_BIRTH_RESULTS
 BI Publisher XML
SSP Statutory Adoption Pay
Imported from BI Publisher Description: Statutory Adoption Pay Report Application: SSP Source: Statutory Adoption Pay Report (XML) Short Name: SSPRPSAP_XML DB package: SSP_SSPRPSAP_XMLP_PKG
 BI Publisher XML
SSP Statutory Maternity Pay
Imported from BI Publisher Description: Statutory Maternity Pay Report Application: SSP Source: Statutory Maternity Pay Report (XML) Short Name: SSPRPSMP_XML DB package: SSP_SSPRPSMP_XMLP_PKG
 BI Publisher XML
SSP Statutory Paternity Adoption Pay
Imported from BI Publisher Description: Statutory Paternity Adoption Pay Report Application: SSP Source: Statutory Paternity Adoption Pay Report (XML) Short Name: SSPRPSPPA_XML DB package: SSP_SSPRPSPA_XMLP_PKG
 BI Publisher XML
SSP Statutory Paternity Birth Pay
Imported from BI Publisher Description: Statutory Paternity Birth Pay Report Application: SSP Source: Statutory Paternity Birth Pay Report (XML) Short Name: SSPRPSPPB_XML DB package: SSP_SSPRPSPB_XMLP_PKG
 BI Publisher XML
SSP Statutory Shared Parental Adoption Pay
Imported from BI Publisher Description: Statutory Paternity Adoption Pay Report Application: SSP Source: Statutory Shared Parental Adoption Pay Report(XML) Short Name: SSPSHPAP DB package: SSP_SHARED_ADOPTION_PAY
 BI Publisher XML
SSP Statutory Shared Parental Birth Pay
Imported from BI Publisher Description: Statutory Paternity Adoption Pay Report Application: SSP Source: Statutory Shared Parental Birth Pay Report(XML) Short Name: SSPSHPBP DB package: SSP_SHARED_BIRTH_PAY
 BI Publisher XML
SSP Statutory Sick Pay
Imported from BI Publisher Description: Statutory Sick Pay Report Application: SSP Source: Statutory Sick Pay Report (XML) Short Name: SSPRPSSP_XML DB package: SSP_SSPRPSSP_XMLP_PKG
 BI Publisher 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
Skeleton ecc
Imported from Enterprise Command Center Dataset Key: ar-trx Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
 XML
Spt Material ETC / EAC Report XML
Supply Chain Hub - MRP Release Diagnostics XML
TB Accounts Payables Trial Balance - FSSC
Imported from BI Publisher Application: TB Custom Reports Source: TB Accounts payables trial balance-NEW Short Name: XXTBXLAAP1 DB package:
 BI Publisher XML
TB GL Account Analysis (Drilldown)v2
Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. This report is used by the GL Financial Statement and Drilldown report, to show subledger details. This also has inventory and WIP details.
 Tiger Custom XML
TB GL Account Analysis (Drilldown)v3
Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. This report is used by the GL Financial Statement and Drilldown report, to show subledger details. This also has inventory and WIP details.
 Tiger Custom XML
TB GL Journals (Drilldown)
GL batches and journals report, including amounts and attachments. This report is used by the GL Financial Statement and Drilldown report, to show subledger details. To enable next level drilldown below columns should be present in Display columns of the custom templates Drill To Subledger Drill To Journal Attachment Drill To Full Journal
 Tiger Custom XML
TMEIC Purchase Register
Purchase Register showing GRN, PO, AP invoice and GST tax details with UNION ALL structure matching TMIND_PURREG_REP.
 XML
Template Style sheets XML
Terex Daily Order Items Revenue Report
Report:Terex Daily Order Items Revenue Report PVCS Code : Terex_Daily_Order_Items_Revenue_Report.xml Default from Date:Starting of Current Month Default Date to :Current Date Report Set move Files to /TMSCIFS/Blitz/MP-Parts/Daily Order Items Revenue
 XML
Train Item Listing XML
Train Items XML
Train Order Managment
query sales for OM
 XML
WH Notifications disabled
This may be done by the users on purpose, or by the system because of a problem with a bad email address. It is recommended to verify all the email addresses Users that have DISABLED notification preference using :
 XML
WIP - Senfor Intl Production Job Details
2May2025
 Manufacturing XML
WIP Account Summary
Imported from BI Publisher Description: WIP Account Summary Report Application: Work in Process Source: WIP Account Summary Report (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Discrete Job Data
Imported from BI Publisher Description: Discrete Job Data Report Application: Work in Process Source: Discrete Job Data Report (XML) Short Name: WIPDJDAT_XML DB package: WIP_WIPDJDAT_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Discrete Job Value Report - Standard Costing
Imported from BI Publisher Description: Discrete Job Value Report - Standard Costing Application: Work in Process Source: Discrete Job Value Report - Standard Costing (XML) Short Name: WIPRDJVR_XML DB package: WIP_WIPRDJVR_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Employee Rates Listing
Imported from BI Publisher Description: Employee Rates Listing Application: Work in Process Source: Employee Rates Listing (XML) Short Name: WIPSUEMP_XML DB package: WIP_WIPSUEMP_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Expense Job Value
Imported from BI Publisher Description: Expense Job Value Report Application: Work in Process Source: Expense Job Value Report (XML) Short Name: WIPREJVR_XML DB package: WIP_WIPREJVR_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Job Schedule Interface Manufacturing XML
WIP Job and Schedule Interface
Imported from BI Publisher Description: Job and Schedule Interface Report Application: Work in Process Source: Job and Schedule Interface Report (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG
 Manufacturing BI Publisher XML
WIP MES Job Traveler Data Template
Application: Work in Process Source: Short Name: WIPMESDATT DB package:
 Manufacturing BI Publisher XML
WIP Mass Return Components for Serialized Assembly
Application: Work in Process Source: Mass Return Components for Serialized Assembly Report Short Name: WIPDEKIT_XML DB package: WIP_WIPDEKIT_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Offsetting Account
Imported from BI Publisher Description: WIP Offsetting Account Report Application: Work in Process Source: WIP Offsetting Account Report (XML) Short Name: WIPUTOAC_XML DB package: WIP_WIPUTOAC_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Parameters
Imported from BI Publisher Description: WIP Parameters Report Application: Work in Process Source: WIP Parameters Report (XML) Short Name: WIPSUPMT_XML DB package: WIP_WIPSUPMT_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Repetitive Pick List
Imported from BI Publisher Description: Repetitive Pick List Report Application: Work in Process Source: Repetitive Pick List Report (XML) Short Name: WIPREPCK_XML DB package: WIP_WIPREPCK_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Repetitive Routing Sheet
Imported from BI Publisher Description: Repetitive Routing Sheet Application: Work in Process Source: Repetitive Routing Sheet (XML) Short Name: WIPRERTG_XML DB package: WIP_WIPRERTG_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Repetitive Schedule Data
Imported from BI Publisher Description: Repetitive Schedule Data Report Application: Work in Process Source: Repetitive Schedule Data Report (XML) Short Name: WIPREDAT_XML DB package: WIP_WIPREDAT_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Repetitive Schedule Shortage
Imported from BI Publisher Description: Repetitive Schedule Shortage Report Application: Work in Process Source: Repetitive Schedule Shortage Report (XML) Short Name: WIPREORQ_XML DB package: WIP_WIPREORQ_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Repetitive Value
Imported from BI Publisher Description: Repetitive Value Report Application: Work in Process Source: Repetitive Value Report (XML) Short Name: WIPREVAL_XML DB package: WIP_WIPREVAL_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Resource Performance
Imported from BI Publisher Description: Resource Performance Report Application: Work in Process Source: Resource Performance Report (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG
 Manufacturing BI Publisher XML
WIP Senfor Intl WIP Production Job Details
This program extracts job details with release and operation dates and elapsed times according to when the transactions were entered in Oracle. It is allows identifying job details to the operation level delays in production, for example when an operation is not completed or exceeds the time expected. The report can be run by any combination of organization, release dates, job, assembly, job status. License: Creative commons with Attribution by Ion Yılmaz, Senfor International, www.senfor-intl.eu
 Manufacturing Senfor International, WIP Senfor Intl XML
WMS ASN DISCREPANCY
Application: Warehouse Management Source: WMS ASN DISCREPANCY REPORT (XML) Short Name: WMSASNI_XML DB package: WMS_WMSASNI_XMLP_PKG
 BI Publisher XML
WMS Consolidation
Application: Warehouse Management Source: Consolidation Report (XML) Short Name: WMSSTCON_XML DB package: WMS_WMSSTCON_XMLP_PKG
 BI Publisher XML
WMS Scheduled Shipment Report (Without Barcodes)
Application: Warehouse Management Source: Scheduled Shipment Report (Without Barcodes) (XML) Short Name: WMSSCHS1_XML DB package: WMS_WMSSCHS1_XMLP_PKG
 BI Publisher XML
WMS Warehouse Space Utilization
Application: Warehouse Management Source: Warehouse Space Utilization Report (XML) Short Name: WMSCPTYR_XML DB package: WMS_WMSCPTYR_XMLP_PKG
 BI Publisher XML
WSH Auto Ship Confirm
Imported from BI Publisher Application: Shipping Execution Source: Auto Ship Confirm Report (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG
 Order Management BI Publisher XML
WSH Auto-pack
Imported from BI Publisher Application: Shipping Execution Source: Auto-pack Report (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG
 Order Management BI Publisher XML
WSH Bill of Lading
Imported from BI Publisher Description: Bill of Lading Application: Shipping Execution Source: Bill of Lading (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG
 Order Management BI Publisher XML