Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

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

1,744 reports

	Description
JE Italian Annual Customer and Supplier Listing	Application: European Localizations Source: Italian Annual Customer and Supplier Listing Short Name: JEITLSTR_XMLP DB package: JE_IT_XML_LISTING_PKG	BI Publisher
JE Italian B2G Electronic Invoices XML File Output	Application: European Localizations Source: Italian B2G Electronic Invoices XML File Output Short Name: JEITEIFO_XMLP DB package: JE_IT_B2G_ELECTRONIC_FILE	BI Publisher
JE Italian Journal Ledger	Imported from BI Publisher Application: European Localizations Source: Italian Journal Ledger Report Short Name: JEITJNLLG DB package: JE_IT_JELINES_RPT_PKG	BI Publisher
JE Italian Payables Exemption Letter Process	Imported from BI Publisher Description: Process and Print Exemption Letters Application: European Localizations Source: Italian Payables Exemption Letter Process Short Name: JEITAPEX_XMLP DB package: JE_IT_EXEM_RPT_PKG	BI Publisher
JE Italian Payables Exemption Letter Process- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Process and Print Exemption Letters Application: European Localizations Source: Italian Payables Exemption Letter Process (XML) - Not Supported: Reserved For Future Use Short Name: JEITAPEX_XML DB package: JE_JEITAPEX_XMLP_PKG	BI Publisher
JE Italian Payables Exemption Letter Register- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Italian Payables Exemption Letter Register Application: European Localizations Source: Italian Payables Exemption Letter Register (XML) - Not Supported: Reserved For Future Use Short Name: JEITXLRG_XML DB package: JE_JEITXLRG_XMLP_PKG	BI Publisher
JE Italian Payables Summary VAT	Imported from BI Publisher Application: European Localizations Source: Italian Payables Summary VAT Report Short Name: JEITPSSR_XMLP DB package: jg_zz_summary_all_pkg	BI Publisher
JE Italian Polyvalent Declaration - Audit Report (Obsolete)	Imported from BI Publisher Description: Italian Invoices Above Threshold - Auditing Report Application: European Localizations Source: Italian Polyvalent Declaration - Audit Report (Obsolete) Short Name: JEITPDAR_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG	BI Publisher
JE Italian Polyvalent Declaration - Electronic File (Obsolete)	Imported from BI Publisher Description: Italian Polyvalent Declaration - Electronic File Application: European Localizations Source: Italian Polyvalent Declaration - Electronic File (Obsolete) Short Name: JEITPDEF_XMLP DB package: JE_IT_POLYVALENT_DECL_RPT_PKG	BI Publisher
JE Italian Purchase VAT Register	Imported from BI Publisher Application: European Localizations Source: Italian Purchase VAT Register Short Name: JEITAPPV_XMLP DB package: jg_zz_journal_ap_pkg	BI Publisher
JE Italian Receivables Deferred VAT Register	Imported from BI Publisher Description: Deferred VAT Register Application: European Localizations Source: Italian Receivables Deferred VAT Register Short Name: JEITRDVR_XMLP DB package: jg_zz_journal_ar_pkg	BI Publisher
JE Italian Sales VAT Register	Imported from BI Publisher Application: European Localizations Source: Italian Sales VAT Register Short Name: JEITARSV_XMLP DB package: jg_zz_journal_ar_pkg	BI Publisher
JE Italian Sales VAT Register (Self Invoices, EEC, VAT)	Imported from BI Publisher Application: European Localizations Source: Italian Sales VAT Register (Self Invoices, EEC, VAT) Short Name: JEITAPSR_XMLP DB package: jg_zz_journal_ap_pkg	BI Publisher
JE Italian Statutory Report Heading	Imported from BI Publisher Description: Produces Pre-printed Report Headers Application: European Localizations Source: Italian Statutory Report Heading Short Name: JEITRGRH DB package: JG_ZZ_RGRH_PKG	BI Publisher
JE Italian Withholding Yearly	Application: European Localizations Source: Italian Withholding Yearly Report Short Name: JEITWHYL_XMLP DB package: JE_ITWHYE_AP_PKG	BI Publisher
JE Norwegian GEI A-Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Norwegian GEI A-Report Application: European Localizations Source: Norwegian GEI A-Report (XML) - Not Supported: Reserved For Future Use Short Name: JENOGEIA_XML DB package: JE_JENOGEIA_XMLP_PKG	BI Publisher
JE Norwegian GEI Print Messages- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Norwegian GEI Print Messages Application: European Localizations Source: Norwegian GEI Print Messages (XML) - Not Supported: Reserved For Future Use Short Name: JENOGEIM_XML DB package: JE_JENOGEIM_XMLP_PKG	BI Publisher
JE Norwegian GEI S-	Application: European Localizations Source: Norwegian GEI S-Report (XML) Short Name: JENOGEIS_XMLP DB package: JE_NO_SREPORT_PKG	BI Publisher
JE Online VAT Register Reporting for Spain	Application: European Localizations Source: Online VAT Register Reporting for Spain Short Name: JEESOVRR_XMLP DB package: je_es_online_vat_ext_pkg	BI Publisher
JE Online VAT Response Status Report for Spain	Application: European Localizations Source: Online VAT Response Status Report for Spain Short Name: JEESOVSR_XMLP DB package:	BI Publisher
JE Polish Supplier Statement- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Polish Supplier Statement Application: European Localizations Source: Polish Supplier Statement (XML) - Not Supported: Reserved For Future Use Short Name: JEPLPSSR_XML DB package: JE_JEPLPSSR_XMLP_PKG	BI Publisher
JE Portuguese Annual VAT	Imported from BI Publisher Application: European Localizations Source: Portuguese Annual VAT Report Short Name: JEPTAVAT_XMLP DB package: jg_zz_summary_all_pkg	BI Publisher
JE Portuguese Payables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Portuguese Payables Taxpayer ID Exception Report Application: European Localizations Source: Portuguese Payables Taxpayer ID Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: JEPTAPER_XML DB package: JE_JEPTAPER_XMLP_PKG	BI Publisher
JE Portuguese Periodic VAT	Imported from BI Publisher Application: European Localizations Source: Portuguese Periodic VAT Report Short Name: JEPTPVAT_XMLP DB package: jg_zz_summary_all_pkg	BI Publisher
JE Portuguese Receivables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Receivables Taxpayer ID Exception Report Application: European Localizations Source: Portuguese Receivables Taxpayer ID Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: JEPTARER_XML DB package: JE_JEPTARER_XMLP_PKG	BI Publisher
JE Spanish Annual Modelo Magnetic Format	Imported from BI Publisher Description: Spanish Annual Modelo Magnetic Format Reporta Application: European Localizations Source: Spanish Annual Modelo Magnetic Format Report Short Name: JEESAMOR_XMLP DB package: je_es_modelo_ext_pkg	BI Publisher
JE Spanish B2G Electronic Invoices XML File Output	Application: European Localizations Source: Spanish B2G Electronic Invoices XML File Output Short Name: JEESEIFO_XMLP DB package: JE_ES_B2G_ELECTRONIC_FILE	BI Publisher
JE Spanish Input VAT Journal	Imported from BI Publisher Application: European Localizations Source: Spanish Input VAT Journal Report Short Name: JEESRPVP_XMLP DB package: jg_zz_journal_ap_pkg	BI Publisher
JE Spanish Inter-EU Invoice Format (Documento Equivalente)	Imported from BI Publisher Application: European Localizations Source: Spanish Inter-EU Invoice Format (Documento Equivalente) Short Name: JEESDOCE_XMLP DB package: JG_ZZ_AUDIT_AP_PKG	BI Publisher
JE Spanish Inter-EU Invoices Journal	Imported from BI Publisher Application: European Localizations Source: Spanish Inter-EU Invoices Journal Report Short Name: JEESRVAR_XMLP DB package: jg_zz_journal_ap_pkg	BI Publisher
JE Spanish Output VAT Journal	Imported from BI Publisher Description: Spanish VAT Received Report Application: European Localizations Source: Spanish Output VAT Journal Report Short Name: JEESRRVR_XMLP DB package: jg_zz_journal_ar_pkg	BI Publisher
JE Spanish Periodic Modelo	Imported from BI Publisher Application: European Localizations Source: Spanish Periodic Modelo Report Short Name: JEESPMOR_XMLP DB package: je_es_modelo_ext_pkg	BI Publisher
JE Swiss Payables VAT	Imported from BI Publisher Application: European Localizations Source: Swiss Payables VAT Report Short Name: JECHAPVT_XMLP DB package: JG_ZZ_AUDIT_AP_PKG	BI Publisher
JE UAE VAT	Imported from BI Publisher Application: European Localizations Source: UAE VAT Report Short Name: JEAEVA01_XMLP DB package: jg_zz_summary_all_pkg	BI Publisher
JE UK Reverse Charge Sales List	Application: European Localizations Source: UK Reverse Charge Sales List Report Short Name: JEUKRSLR_XMLP DB package: JE_REVERSE_SALES_LIST_PKG	BI Publisher
JG ECE General Ledger VAT Register	Imported from BI Publisher Application: Regional Localizations Source: ECE General Ledger VAT Register Short Name: JGZZGLVR_XMLP DB package: JG_ZZ_AUDIT_GL_PKG	BI Publisher
JG ECE Payables VAT Register	Imported from BI Publisher Application: Regional Localizations Source: ECE Payables VAT Register Short Name: JGZZAPVR_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG	BI Publisher
JG ECE Receivables VAT Register	Imported from BI Publisher Description: ECE Receivables VAT Register Report Application: Regional Localizations Source: ECE Receivables VAT Register Short Name: JGZZARVR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG	BI Publisher
JG EMEA VAT: Allocation Errors Listing	Application: Regional Localizations Source: EMEA VAT: Allocation Errors Listing Short Name: JGZZAERL DB package: JG_ZZ_AERL_DT_PKG	BI Publisher
JG EMEA VAT: Allocation Rules Listing	Imported from BI Publisher Description: Allocation Rules Listing Application: Regional Localizations Source: EMEA VAT: Allocation Rules Listing Short Name: JGZZALRL DB package: JG_ZZ_JGZZALRL_PKG	BI Publisher
JG EMEA VAT: Allocations Listing	Application: Regional Localizations Source: EMEA VAT: Allocations Listing Short Name: JGZZALST DB package:	BI Publisher
JG EMEA VAT: Audit AP Extract	Application: Regional Localizations Source: EMEA VAT: Audit AP Extract Short Name: JGZZAUDITAP_XMLP DB package: JG_ZZ_AUDIT_AP_PKG	BI Publisher
JG EMEA VAT: Audit AP Non TRL Extract	Imported from BI Publisher Description: Audit AP Non TRL Extract Application: Regional Localizations Source: EMEA VAT: Audit AP Non TRL Extract Short Name: JGZZAPAE_NTRL_XMLP DB package: JE_ZZ_AUDIT_AP_PKG	BI Publisher
JG EMEA VAT: Audit AR Extract	Application: Regional Localizations Source: EMEA VAT: Audit AR Extract Short Name: JGZZAUDITAR_XMLP DB package: jg_zz_audit_ar_pkg	BI Publisher
JG EMEA VAT: Audit GL Extract	Application: Regional Localizations Source: EMEA VAT: Audit GL Extract Short Name: JGZZAUDITGL_XMLP DB package: JG_ZZ_AUDIT_GL_PKG	BI Publisher
JG EMEA VAT: Journal AP Extract	Application: Regional Localizations Source: EMEA VAT: Journal AP Extract Short Name: JGZZJOURNALAP_XMLP DB package: jg_zz_journal_ap_pkg	BI Publisher
JG EMEA VAT: Journal AR Extract	Application: Regional Localizations Source: EMEA VAT: Journal AR Extract Short Name: JGZZJOURNALAR_XMLP DB package: jg_zz_journal_ar_pkg	BI Publisher
JG EMEA VAT: Summary AP Extract	Application: Regional Localizations Source: EMEA VAT: Summary AP Extract Short Name: JGZZSUMMARYAP_XMLP DB package: JG_ZZ_SUMMARY_AP_PKG	BI Publisher
JG EMEA VAT: Summary AR Extract	Application: Regional Localizations Source: EMEA VAT: Summary AR Extract Short Name: JGZZSUMMARYAR_XMLP DB package: JG_ZZ_SUMMARY_AR_PKG	BI Publisher
JG EMEA VAT: Summary All Extract	Application: Regional Localizations Source: EMEA VAT: Summary All Extract Short Name: JGZZSUMMARYALL_XMLP DB package: jg_zz_summary_all_pkg	BI Publisher

Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

Also found in SQL, tables and columns