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
R12 only

22 reports

DescriptionDownload
GL Balance by Account Hierarchy
Summary GL report including one line per GL account. This report has multiple collapsible/expandable summary levels based on the GL account hierarchy, with starting balance, total amount per month, ending total and YTD balance. Parameter 'Additional Segment' can be used to include additional segments e.g. cost center or balancing segment.
 General Ledger Enginatics, R12 only XLS XML
GL Chart of Accounts Mapping Rules
Lists the segment mapping rules and code combination mappings defined for a Global Consolidation System (GCS) chart of accounts mapping. Converted from the Oracle BI Publisher report 'Chart of Accounts - Mapping Rules (XML)' (GLXCOCRR_XML).
 General Ledger Enginatics, R12 only XLS XML
GL Data Access Sets
Master data report showing ledger security. Listing of all GL data access sets and the ledgers or ledger sets that each access set can access. Show Responsibilities adds one row per responsibility using the access set through the GL: Data Access Set profile set at responsibility or application level. Responsibilities inheriting the site level value are not listed. Summary Accounts Allowed shows Yes when the responsibility's menu grants the Summary Accounts form and the access set gives full read and write access to the whole ledger. Otherwise the form's Ledger list does not offer the ledger…
full description		 General Ledger Enginatics, R12 only XLS XML
GL FSG Reports
Financial Statement Generator reports
 General Ledger Enginatics, R12 only XLS XML
GL FSG Row Orders
Financial Statement Generator row order listing
 General Ledger Enginatics, R12 only XLS XML
GL Ledger Sets
Master data report showing GL ledger sets and included ledgers.
 General Ledger Enginatics, R12 only XLS XML
GL Ledgers and Legal Entities
Master data report showing ledger set, ledger name, ledger category, currency, legal entity, and balancing segment across all ledgers and legal entities.
 General Ledger Enginatics, R12 only XLS XML
GL Periods
Geleral ledger calendars and accounting periods
 General Ledger Enginatics, R12 only XLS XML
GL Trial Balance - Detail
Imported from Concurrent Program Description: Detail Trial Balance (XML) Application: General Ledger Source: Trial Balance - Detail (XML) Short Name: GLTRBALD DB package:
 General Ledger Enginatics, R12 only XLS XML
GL effective vs accounting vs period start and end date comparison
For developers to understand the GL data: Shows the relationship between effective, accounting and period start and end dates by counting how many records exist where the effective date is before or after the accounting date.
 General Ledger Enginatics, R12 only XLS XML
XLA Distribution Links Summary
Summary of subledger distribution links for developers to understand which source_ids are populated for which subledger table sources. The link to subledger tables for different source_distribution_type values is described e.g. MOS Doc IDs for: AP KB202448 https://support.oracle.com/support/?kmContentId=813968 FA KB721213 https://support.oracle.com/support/?kmContentId=2002464 PA KB160029 https://support.oracle.com/support/?kmContentId=1274575 For GMF, there is AP and PO Accrual Reconciliation Report Debugging from OPM Financials KB775263…
full description		 General Ledger Enginatics, R12 only XLS XML
XLA Entity ID Mappings
Shows the column link between table xla_transaction_entities and subledger source tables such as and AP invoice_id or AR customer_trx_id, used when writing queries linking GL to subledger such as the GL Account Analysis report www.enginatics.com/reports/gl-account-analysis/
 General Ledger Enginatics, R12 only XLS XML
XLA Entity Types and Event Class Attributes
Subledger event types and their attributes, for example reporting view
 General Ledger Enginatics, R12 only XLS XML
XLA OPM Event Type Summary General Ledger Enginatics, R12 only XLS XML
XLA Subledger Accounting Rules Detail Listing
Lists the complete Subledger Accounting rule setup in one flat grid, combining the seven separate queries of the Oracle standard XLASARDLR Subledger Accounting Rules Detail Listing BI Publisher report. There is one row per journal line type and account derivation rule priority, so the accounting method, application accounting definition, event class and type, journal line definition, journal line type, segment, derivation rule, its priority, condition and derived value all sit on the same row and can be filtered and pivoted directly. Journal line type and account derivation rule conditions…
full description		 General Ledger Enginatics, R12 only XLS XML
XLA Subledger Period Close Exceptions
Imported from BI Publisher Description: This report extracts 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 Enginatics, R12 only XLS XML
GL Account Analysis (Drilldown)
** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. ** Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. For drilldown to the transaction screen please ensure the column View Transaction is present in the Displayed Columns View Transaction
 General Ledger Enginatics, R12 only XML
GL Account Analysis (Drilldown) (with inventory and WIP)
** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. ** Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. This also has inventory and WIP details.
 General Ledger Enginatics, R12 only XML
GL Account Distribution Analysis
Detailed GL transaction report with one line per distribution including all segments and subledger data, with amounts in both transaction currency and ledger currency. The report includes VAT tax codes and rates for AR and AP transactions.
 General Ledger Enginatics, R12 only XML
GL Journals (Drilldown)
** This report is used by the GL Financial Statement and Drilldown report, to show Journal details. ** GL batches and journals report, including amounts and attachments.To enable next level drilldown below columns should be present in Display columns of the custom templates Drill To Subledger Drill To Journal Attachment Drill To Full Journal
 General Ledger Enginatics, R12 only XML
GL Setup Upload
Create and update the General Ledger setup entities that the GL Setup menu maintains, replicating the Calendars (GLXSTCAL), Period Types (GLXSTPTY), Journal Sources (GLXSTSRC), Journal Categories (GLXSTCAT), Encumbrance Types (GLXSTENC), Statistical Units of Measure (GLXSTUOM), Ledger Sets (GLXSTLST), Data Access Sets (GLXSTACC), Journal Reversal Criteria (GLXSTARV) and AutoPost Criteria (GLXSTAPO) forms, plus ledger options. Each row is one of fifteen entity types, chosen in the Row Type column. Only the columns belonging to that entity are read; all other columns are ignored. A template is…
full description		 General Ledger Enginatics, R12 only, Upload XML
GL Summary Account Upload
This upload can be used to import Summary Account Templates.
 General Ledger Enginatics, R12 only, Upload XML