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
JE Italian Annual Customer and Supplier Electronic Format
Imported from BI Publisher Application: European Localizations Source: Italian Annual Customer and Supplier Electronic Format Short Name: JEITLSTE_XMLP DB package: JE_IT_XML_LISTING_PKG
 BI Publisher XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
JE Italian Withholding Yearly
Application: European Localizations Source: Italian Withholding Yearly Report Short Name: JEITWHYL_XMLP DB package: JE_ITWHYE_AP_PKG
 BI Publisher XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
JG EMEA VAT: Allocations Listing
Application: Regional Localizations Source: EMEA VAT: Allocations Listing Short Name: JGZZALST DB package:
 BI Publisher XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML