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
Custom Reports HDFC

3 reports

DescriptionDownload
AP Consolidated Invoices
AP invoices and distributions from the HDFC consolidated view, with the full set of invoice, distribution, payment, travel/expense, account, cost centre, branch, banking, TDS, WCT, ESI and GST attributes. Migrated from the Oracle Discoverer worksheet built on HDFC.HDFC_CONSOLIDATED_VW. Invoice Line Number, Available Amount, CESS Amount, Total Tax Amount and TDS Rate are summed for each unique combination of all other columns, and the Discoverer Year/Quarter/Month/Day date buckets for Invoice GL Date, Created Date, Prepaid Invoice Date, Hold Date, Release Date, GL Date and Payment Date are…
full description		 Payables Custom Reports HDFC XML
AP Never Validated Invoices
AP invoices and distributions that were never validated, sourced from the HDFC combined view, with the full set of invoice, distribution, account, cost centre, branch, banking, requestor, expense, TDS and GST attributes. Migrated from the Oracle Discoverer worksheet built on APPS.HDFC_AP_NEVER_VALID_COMBINED_V. Available Amount and Distribution Line Number are summed for each unique combination of all other columns, and the Discoverer Day/Month/Quarter/Year date buckets for Distribution Accounting Date, GL Date and Terms Date are retained. Enter a GL Date to report on a single accounting…
full description		 Payables Custom Reports HDFC XML
AP TDS Details Report
TDS (Tax Deducted at Source) invoice details for India Form 17, joining the HDFC TDS detail table to AP Invoices for the supplier attribute / supplier tax invoice number columns. The TDS detail table HDFC.XXHDFC_AP_TDS_DETAILS_TBL is not queried directly from your transactional tables. It is first populated for the entered Tax Invoice Due Date by the HDFC_TDS_DETAILS concurrent program (XXHDFC TDS Details Report). This report runs that program automatically through its DB package before-report trigger (XXHDFC_TDS_REPORT_PKG.beforereport), waits for it to complete, and then returns the…
full description		 Payables Custom Reports HDFC XML