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

143 reports

DescriptionDownload
GL Journals - Tax
Imported from BI Publisher Description: Tax Journals Report Application: General Ledger Source: Journals - Tax (XML) Short Name: GLXJETAX_XML DB package: GL_GLXJETAX_XMLP_PKG
 General Ledger BI Publisher XML
GL Journals - Voucher
Imported from BI Publisher Description: Journals - Voucher Application: General Ledger Source: Journals - Voucher (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG
 General Ledger BI Publisher XML
GL MoFU KPI Dashboard
Ministry of Finance Uganda - KPI exception counts summarised by Vote Code. 35 KPI codes across GL, AR, CM, AP, PO, BU and FA modules. One row per vote code, one column per KPI. Use GL MoFU KPI Dashboard Exceptions to drill into detail.
 General Ledger GL XML
GL MoFU KPI Dashboard Exceptions
Ministry of Finance Uganda - KPI exceptions at transaction level across GL, AR, CM, AP, PO, BU, and FA modules by Vote Code. Use Module and KPI Code parameters to drill into a specific exception type.
 General Ledger GL XML
GL Open Balances Revaluation
Imported from BI Publisher Description: GL Open Balances Revaluation Report for Slovakia Application: General Ledger Source: GL Open Balances Revaluation Report Short Name: GLXOBRVR DB package: gl_open_bal_reval_rpt_pkg
 General Ledger BI Publisher XML
GL Oracle FSG Converter (modified)
The GL Oracle FSG Converter is used for migration of financial statement reports from Oracle Financial Statement Generator (FSG) into the GL Financial Statement and Drilldown (FSG) report. This converter simplifies the process of transferring the existing Oracle FSG reports, allowing users to leverage advanced reporting and drilldown capabilities with minimal setup. This version supports DB versions above 12c. To apply the converter, the profile 'Blitz FSG Oracle to Blitz Report Converter' must be updated with the relevant report name based on the db version. For a quick demonstration of GL…
full description		 General Ledger XML
GL Other - Calendar Validation
Application: General Ledger Source: Other - Calendar Validation Report (XML) Short Name: GLXCLVAL_XML DB package: GL_GLXCLVAL_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - Data Access Set Listing
Application: General Ledger Source: Other - Data Access Set Listing (XML) Short Name: GLXDALST_XML DB package: GL_GLXDALST_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - Definition Access By User
Application: General Ledger Source: Other - Definition Access By User (XML) Short Name: GLXDFUSR_XML DB package: GL_GLXDFUSR_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - Definition Access Set Listing
Application: General Ledger Source: Other - Definition Access Set Listing (XML) Short Name: GLXDFLST_XML DB package: GL_GLXDFLST_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - Ledger Set Listing
Application: General Ledger Source: Other - Ledger Set Listing (XML) Short Name: GLXLSLST_XML DB package: GL_GLXLSLST_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - MassAllocation Formula Listing
Imported from BI Publisher Description: Mass Allocations Formula Listing Report Application: General Ledger Source: Other - MassAllocation Formula Listing (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - Recurring Formula Listing
Imported from BI Publisher Description: Recurring Journal and Budget Formula Listing Application: General Ledger Source: Other - Recurring Formula Listing (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - Transaction Code Listing
Application: General Ledger Source: Other - Transaction Code Listing (XML) Short Name: GLXRLTCL_XML DB package: GL_GLXRLTCL_XMLP_PKG
 General Ledger BI Publisher XML
GL Other - Value Added Tax
Imported from BI Publisher Description: VAT report by period,currency and tax code Application: General Ledger Source: Other - Value Added Tax (XML) Short Name: GLXRLVAT_XML DB package: GL_GLXRLVAT_XMLP_PKG
 General Ledger BI Publisher XML
GL Reconciliation - Reconciled Transactions
Imported from BI Publisher Description: Reconciled Transaction Report Application: General Ledger Source: Reconciliation - Reconciled Transactions (XML) Short Name: GLXRCTRS_XML DB package: GL_GLXRCTRS_XMLP_PKG
 General Ledger BI Publisher XML
GL Reconciliation - Unreconciled Transactions
Imported from BI Publisher Application: General Ledger Source: Reconciliation - Unreconciled Transactions (XML) Short Name: GLXRCUNR_XML DB package: GL_GLXRCTRS_XMLP_PKG
 General Ledger BI Publisher XML
GL SLA Drillback Diagnostic
GL SLA Drillback Diagnostic
 General Ledger XML
GL Trial Balance - Average
Imported from BI Publisher Description: Average Balance Trial Balance Report Application: General Ledger Source: Trial Balance - Average (XML) Short Name: GLXAVTRB_XML DB package: GL_GLXAVTRB_XMLP_PKG
 General Ledger BI Publisher XML
GL Trial Balance - Budget
Imported from BI Publisher Description: Budget Trial Balance Application: General Ledger Source: Trial Balance - Budget (XML) Short Name: GLXBTB_XML DB package: GL_GLXBTB_XMLP_PKG
 General Ledger BI Publisher XML
GL Trial Balance - Encumbrance
Imported from BI Publisher Description: Encumbrance Trial Balance Application: General Ledger Source: Trial Balance - Encumbrance (XML) Short Name: GLXETB_XML DB package: GL_GLXETB_XMLP_PKG
 General Ledger BI Publisher XML
GL Trial Balance - Expanded
Imported from BI Publisher Description: Expanded Trial Balance Application: General Ledger Source: Trial Balance - Expanded (XML) Short Name: GLYRLBGE_XML DB package: GL_GLYRLBGE_XMLP_PKG
 General Ledger BI Publisher XML
GL Turnover for Selected Segments
Imported from BI Publisher Application: General Ledger Source: Turnover for Selected Segments Report Short Name: GLXSSEGR DB package: GL_SEL_SEG_TURNOVER_RPT_PKG
 General Ledger BI Publisher XML
XLA Account Analysis
Imported from BI Publisher Description: Standard Account Analysis Report Application: Subledger Accounting Source: Account Analysis Report Short Name: XLAAARPT DB package: XLA_ACCT_ANALYSIS_RPT_PKG
 General Ledger BI Publisher XML
XLA Accounts Payables Trial Balance Rebuild
Imported from BI Publisher Application: Subledger Accounting Source: Accounts Payables Trial Balance Rebuild Short Name: XLATBBLD DB package: XLA_TB_REBUILD_PKG
 General Ledger BI Publisher XML
XLA Complete Multiperiod Accounting
Imported from BI Publisher Application: Subledger Accounting Source: Complete Multiperiod Accounting Short Name: XLARPMPA DB package: XLA_MULTIPERIOD_RPRTG_PKG
 General Ledger BI Publisher XML
XLA Create Accounting
Imported from BI Publisher Description: Report for the Accounting Program Application: Subledger Accounting Source: Create Accounting Short Name: XLAACCPB DB package: XLA_CREATE_ACCT_RPT_PVT
 General Ledger BI Publisher XML
XLA Create and Assign Sources- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Create and Assign Sources Report Application: Subledger Accounting Source: Create and Assign Sources (XML) - Not Supported: Reserved For Future Use Short Name: XLAABASR_XML DB package: XLA_XLAABASR_XMLP_PKG
 General Ledger BI Publisher XML
XLA Export Application Accounting Definitions- Not Supported: Reserved For Future Use
Imported from BI Publisher Application: Subledger Accounting Source: Export Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use Short Name: XLAALEXP_XML DB package: XLA_XLAALEXP_XMLP_PKG
 General Ledger BI Publisher XML
XLA Import Initial Balance for Third Party Control Account
Application: Subledger Accounting Source: Import Initial Balance for Third Party Control Account Short Name: XLACAINBAL DB package: XLA_CA_BALANCES_PKG
 General Ledger BI Publisher XML
XLA Import Initial Balances for Supporting References
Application: Subledger Accounting Source: Import Initial Balances for Supporting References Short Name: XLAACSUPREF DB package: XLA_AC_BALANCES_PKG
 General Ledger BI Publisher XML
XLA Journal Entries
Imported from BI Publisher Description: SLA Standard Journal Entry Lines Report Application: Subledger Accounting Source: Journal Entries Report Short Name: XLAJELINESRPT DB package: XLA_JELINES_RPT_PKG
 General Ledger BI Publisher XML
XLA Open Account AP Balances Listing
Imported from BI Publisher Application: Subledger Accounting Source: Open Account AP Balances Listing Short Name: XLAAPRPT DB package: XLA_TB_AP_REPORT_PVT
 General Ledger BI Publisher XML
XLA Open Account Balances Listing
Imported from BI Publisher Application: Subledger Accounting Source: Open Account Balances Listing Short Name: XLATBRPT DB package: XLA_TB_REPORT_PVT
 General Ledger BI Publisher XML
XLA Subledger Multiperiod Accounting and Accrual Reversal
Imported from BI Publisher Description: Report for the Accounting Program Application: Subledger Accounting Source: Subledger Multiperiod Accounting and Accrual Reversal Report Short Name: XLARPMPX DB package: XLA_MPA_ACCRUAL_RPRTG_PKG
 General Ledger BI Publisher XML
XLA Subledger Period Close Exceptions (1)
Imported from BI Publisher Description: This report is called by the Period Close Validation Program to extract all those events which are either untransferred or are not accounted for. Application: Subledger Accounting Source: Subledger Period Close Exceptions Report Short Name: XLAPEXRPT DB package: XLA_PERIOD_CLOSE_EXP_PKG
 General Ledger BI Publisher XML
XLA Third Party Balances
Imported from BI Publisher Description: Standard Third Party Balances Report Application: Subledger Accounting Source: Third Party Balances Report Short Name: XLATPRPT DB package: XLA_TP_BALANCE_RPT_PKG
 General Ledger BI Publisher XML
XLA Trading Partner Summary
Imported from BI Publisher Application: Subledger Accounting Source: Trading Partner Summary Report Short Name: XLATPSUMRPT DB package: XLA_TP_SUMMARY_RPT_PKG
 General Ledger BI Publisher XML
XLA Transfer Journal Entries to GL
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: Subledger Accounting Source: Transfer Journal Entries to GL Short Name: XLAGLTRN DB package: XLA_CREATE_ACCT_RPT_PVT
 General Ledger BI Publisher XML
XLA Trial Balance - Manual SLA AP Amounts
XLA Trial Balance - Manual SLA AP Amounts
 General Ledger XLA Trial Balance Analysis XML
XLA Trial Balance - Non AP Journal Amounts
XLA Trial Balance - Non AP Sourced Journal Amounts
 General Ledger XLA Trial Balance Analysis XML
XLA Trial Balance - Raw Data
xla_trial_balances - Raw Data
 General Ledger XLA Trial Balance Analysis XML
XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Application Accounting Definition Validation Report Application: Subledger Accounting Source: Validate Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG
 General Ledger BI Publisher XML