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 147 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
BI Publisher Service

1,745 reports

DescriptionDownload
JA India - Statement of Accounts for Supplier- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Statement of Accounts for Supplier - India Local Application: Asia/Pacific Localizations Source: India - Statement of Accounts for Supplier (XML) - Not Supported: Reserved For Future Use Short Name: JAINSTAC_XML DB package: JA_JAINSTAC_XMLP_PKG
 BI Publisher XML
JA India - Supplementary Transaction Details - draft
Application: Asia/Pacific Localizations Source: India - Supplementary Transaction Details Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINSITR_XML DB package: JA_JAINSITR_XMLP_PKG
 BI Publisher XML
JA India - TDS Certificates (1)
Imported from BI Publisher Description: Form 16A report Application: Asia/Pacific Localizations Source: India - TDS Certificates (XML) Short Name: JAINITCR_XML DB package: JA_JAINITCR_XMLP_PKG
 BI Publisher XML
JA India - TDS Prescribed Rate - draft
Application: Asia/Pacific Localizations Source: India - TDS Prescribed Rate Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINITCP_XML DB package: JA_JAINITCP_XMLP_PKG
 BI Publisher XML
JA India - TDS Related Invoices - draft
Application: Asia/Pacific Localizations Source: India - TDS Related Invoices (XML) - Not Supported: Reserved For Future Use Short Name: JAINOTDS_XML DB package: JA_JAINOTDS_XMLP_PKG
 BI Publisher XML
JA India - TDS at Lower Rates - draft
Application: Asia/Pacific Localizations Source: India - TDS at Lower Rates Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINITCL_XML DB package: JA_JAINITCL_XMLP_PKG
 BI Publisher XML
JA India - Tax Exemptions Report(XML Publisher)
Application: Asia/Pacific Localizations Source: India - Tax Exemptions Report(XML Publisher) Short Name: JAINTAEM_XML DB package: JAI_EXTRACT_PKG
 BI Publisher XML
JA India - Tax Liability Register Report(XML Publisher)
Application: Asia/Pacific Localizations Source: India - Tax Liability Register Report(XML Publisher) Short Name: JAINLARG_XML DB package: JAI_EXTRACT_PKG
 BI Publisher XML
JA India - Tax Recovery Register Report(XML Publisher)
Application: Asia/Pacific Localizations Source: India - Tax Recovery Register Report(XML Publisher) Short Name: JAINRERG_XML DB package: JAI_EXTRACT_PKG
 BI Publisher XML
JA India - Tax Register Report(XML Publisher)
Application: Asia/Pacific Localizations Source: India - Tax Register Report(XML Publisher) Short Name: JAINTREG_XML DB package: JAI_EXTRACT_PKG
 BI Publisher XML
JA India - Total Sales - draft
Application: Asia/Pacific Localizations Source: India - Total Sales Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINTSLS_XML DB package: JA_JAINTSLS_XMLP_PKG
 BI Publisher XML
JA India - VAT Returns Report(1)- Not Supported: Reserved For Future Use
Imported from BI Publisher Application: Asia/Pacific Localizations Source: India - VAT Returns Report(1) (XML) - Not Supported: Reserved For Future Use Short Name: JAINVATR_XML DB package: JA_JAINVATR_XMLP_PKG
 BI Publisher XML
JA Natural Account Export Exception
Application: Asia/Pacific Localizations Source: Natural Account Export Exception Report Short Name: JACNNAER DB package:
 BI Publisher XML
JA Third Party Detail Trial Balance with Contra Accounts
Imported from BI Publisher Application: Asia/Pacific Localizations Source: Third Party Detail Trial Balance with Contra Accounts Report Short Name: JAJPTPBC DB package: JA_JP_TP_BAL_CTRL_RPT_PKG
 BI Publisher XML
JA Transfer Journal Entries to GL for Asia/Pacific AR and AP
Imported from BI Publisher Description: Use this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program for Asia/Pacific AR and AP Application: Asia/Pacific Localizations Source: Transfer Journal Entries to GL for Asia/Pacific AR and AP Short Name: JAARAPTR DB package: XLA_CREATE_ACCT_RPT_PVT
 BI Publisher XML
JA Transfer Journal Entries to GL for Asia/Pacific FA
Imported from BI Publisher Description: Use this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program Application: Asia/Pacific Localizations Source: Transfer Journal Entries to GL for Asia/Pacific FA Short Name: JAFATRJE DB package: XLA_CREATE_ACCT_RPT_PVT
 BI Publisher XML
JE Annual Online VAT Register Reporting for Spain
Application: European Localizations Source: Annual Online VAT Register Reporting for Spain Short Name: JEESAVRR_XMLP DB package: je_es_annual_vat_ext_pkg
 BI Publisher XML
JE Austrian VAT Reconciliation
Imported from BI Publisher Application: European Localizations Source: Austrian VAT Reconciliation Report Short Name: JEATVATD DB package: JE_AT_VAT_UTIL_PKG
 BI Publisher XML
JE Belgian VAT Annual Audit
Imported from BI Publisher Application: European Localizations Source: Belgian VAT Annual Audit Report Short Name: JEBEVA17_XMLP DB package: jg_zz_audit_ar_pkg
 BI Publisher XML
JE Belgian VAT Annual Declaration Process
Imported from BI Publisher Application: European Localizations Source: Belgian VAT Annual Declaration Process Report Short Name: JEBEVADC_XMLP DB package: jg_zz_turnover_ar_pkg
 BI Publisher XML
JE Belgian VAT Annual Return
Imported from BI Publisher Application: European Localizations Source: Belgian VAT Annual Return Report Short Name: JEBEVA24_XMLP DB package: jg_zz_turnover_ar_pkg
 BI Publisher XML
JE Belgian VAT Monthly VAT Preparation
Imported from BI Publisher Application: European Localizations Source: Belgian VAT Monthly VAT Preparation Report Short Name: JEBEVA06_XMLP DB package: jg_zz_summary_all_pkg
 BI Publisher XML
JE Belgian VAT Purchases Journal
Imported from BI Publisher Application: European Localizations Source: Belgian VAT Purchases Journal Short Name: JEBEDV08_XMLP DB package: jg_zz_journal_ap_pkg
 BI Publisher XML
JE Belgian VAT Sales Journal
Imported from BI Publisher Application: European Localizations Source: Belgian VAT Sales Journal Short Name: JEBEDV07_XMLP DB package: jg_zz_journal_ar_pkg
 BI Publisher XML
JE Croatian Customer Invoice Tax
Imported from BI Publisher Description: Croatia Customer Invoice Tax Report Application: European Localizations Source: Croatian Customer Invoice Tax Report Short Name: JEHRCITR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG
 BI Publisher XML
JE Croatian Supplier Invoice Tax
Imported from BI Publisher Description: Croatia Supplier Invoice Tax Report Application: European Localizations Source: Croatian Supplier Invoice Tax Report Short Name: JEHRVITR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG
 BI Publisher XML
JE Czech Export Tax
Imported from BI Publisher Application: European Localizations Source: Czech Export Tax Report Short Name: JECZAREX_XMLP DB package: jg_zz_audit_ar_pkg
 BI Publisher XML
JE Czech Import Tax
Imported from BI Publisher Application: European Localizations Source: Czech Import Tax Report Short Name: JECZIMPT_XMLP DB package: JG_ZZ_AUDIT_AP_PKG
 BI Publisher XML
JE EMEA VAT: Spanish Modelo Extract
Imported from BI Publisher Description: Spanish Modelo Extract Application: European Localizations Source: EMEA VAT: Spanish Modelo Extract Short Name: JEESMODELOEXT_XMLP DB package: je_es_modelo_ext_pkg
 BI Publisher XML
JE Finnish Deferred Depreciation Expense - draft
Application: European Localizations Source: Finnish Deferred Depreciation Expense Report (XML) - Not Supported: Reserved For Future Use Short Name: JEFIASDR_XML DB package: JE_JEFIASDR_XMLP_PKG
 BI Publisher XML
JE Finnish Payables Account by Detail- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Finnish Payables Account by Detail Application: European Localizations Source: Finnish Payables Account by Detail (XML) - Not Supported: Reserved For Future Use Short Name: JEFILPIP_XML DB package: JE_JEFILPIP_XMLP_PKG
 BI Publisher XML
JE French Accounting Entries Audit File
Imported from BI Publisher Application: European Localizations Source: French Accounting Entries Audit File Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG
 BI Publisher XML
JE French Deductible VAT Declaration
Imported from BI Publisher Application: European Localizations Source: French Deductible VAT Declaration Report Short Name: JEFRTXDC_XMLP DB package: JE_ZZ_AUDIT_AP_PKG
 BI Publisher XML
JE German Payables VAT Reconciliation Detail Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: German Payables VAT Reconciliation Detail Report Application: European Localizations Source: German Payables VAT Reconciliation Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: JEDEAPVR_XML DB package: JE_JEDEAPVR_XMLP_PKG
 BI Publisher XML
JE German VAT for On-Account Receipts
Imported from BI Publisher Description: German VAT for On-Account Receipts Report Application: European Localizations Source: German VAT for On-Account Receipts Short Name: JEDEDVOR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG
 BI Publisher XML
JE Greek Statutory Report Headings
Imported from BI Publisher Description: Produces Pre-printed Report Headers Application: European Localizations Source: Greek Statutory Report Headings Short Name: JEGRRGRH DB package: JG_ZZ_RGRH_PKG
 BI Publisher XML
JE Hungarian Accumulated Depreciation Movement Schedule- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Hungarian Asset Movement Schedule: Accumulated Depreciation Application: European Localizations Source: Hungarian Accumulated Depreciation Movement Schedule (XML) - Not Supported: Reserved For Future Use Short Name: JEHUFAMD_XML DB package: JE_JEHUFAMD_XMLP_PKG
 BI Publisher XML
JE Hungarian Asset Movement Schedule: Gross Changes- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Hungarian Asset Movement Schedule (Gross Changes) Application: European Localizations Source: Hungarian Asset Movement Schedule: Gross Changes (XML) - Not Supported: Reserved For Future Use Short Name: JEHUFAMS_XML DB package: JE_JEHUFAMS_XMLP_PKG
 BI Publisher XML
JE Hungarian Depreciation Analysis- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Hungarian Depreciation Analysis Application: European Localizations Source: Hungarian Depreciation Analysis (XML) - Not Supported: Reserved For Future Use Short Name: JEHUFDAN_XML DB package: JE_JEHUFDAN_XMLP_PKG
 BI Publisher XML
JE Hungarian Payables Invoice Aging - draft
Application: European Localizations Source: Hungarian Payables Invoice Aging Report (XML) - Not Supported: Reserved For Future Use Short Name: JEHUIAGE_XML DB package: JE_JEHUIAGE_XMLP_PKG
 BI Publisher XML
JE Invoice Electronic Listing File for Italy
Application: European Localizations Source: Invoice Electronic Listing File for Italy Short Name: JEITIELF_XMLP DB package: JE_IT_ELE_INV_REPORT_PKG
 BI Publisher XML
JE Israeli Summary VAT to Tax Authorities
Imported from BI Publisher Application: European Localizations Source: Israeli Summary VAT to Tax Authorities Short Name: JEILSVAT_XMLP DB package: jg_zz_summary_all_pkg
 BI Publisher XML
JE Israeli VAT AP Detail Register
Imported from BI Publisher Application: European Localizations Source: Israeli VAT AP Detail Register Report Short Name: JEILAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG
 BI Publisher XML
JE Israeli VAT AR Detail Register
Imported from BI Publisher Application: European Localizations Source: Israeli VAT AR Detail Register Report Short Name: JEILARDR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG
 BI Publisher XML
JE Israeli VAT File Non Related to 835
Imported from BI Publisher Application: European Localizations Source: Israeli VAT File Non Related to 835 Short Name: JEILN835_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG
 BI Publisher XML
JE Israeli VAT File Related to 835
Imported from BI Publisher Application: European Localizations Source: Israeli VAT File Related to 835 Short Name: JEILR835_XMLP DB package: jg_zz_summary_all_pkg
 BI Publisher XML
JE Israeli Withholding Annual Certificate To Vendors
Imported from BI Publisher Application: European Localizations Source: Israeli Withholding Annual Certificate To Vendors Report Short Name: JEILAVCR DB package: JE_IL_TAX_PKG
 BI Publisher XML
JE Israeli Withholding Tax File to Tax Authority
Imported from BI Publisher Application: European Localizations Source: Israeli Withholding Tax File to Tax Authority Short Name: JEILWHTT DB package: JE_IL_TAX_PKG
 BI Publisher XML
JE Israeli Withholding Tax Reconciliation
Imported from BI Publisher Application: European Localizations Source: Israeli Withholding Tax Reconciliation Report Short Name: JEILWHTR DB package: JE_IL_TAX_PKG
 BI Publisher XML
JE Israeli Withholding Tax Summary/Detail
Imported from BI Publisher Application: European Localizations Source: Israeli Withholding Tax Summary/Detail Report Short Name: JEILWHTD DB package: JE_IL_TAX_PKG
 BI Publisher XML