Oracle EBS General Ledger Reports
29 ready-to-run SQL reports for Oracle E-Business Suite General Ledger, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used General Ledger tables in these reports are gl_ledgers, gl_code_combinations_kfv, gl_periods, gl_daily_conversion_types, gl_je_headers, gl_je_lines.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
General Ledger SQL Reports
| Report | Description |
|---|---|
| GL Account Analysis | Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger… |
| GL Account Analysis 11g | Backwards compatible version (for 11g databases) of the detail GL transaction report with one line per transaction including all segments and subledger data… |
| 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… |
| GL Balance | Summary GL report including one line per accounting period for each account segment level, including product code, with amounts for opening balance, debits… |
| GL Balance (pivot) | Summary GL report including one line per account segment level, including product code, with opening balance, total transaction amount per month for each… |
| GL Balance Drilldown | Shows GL balance details by code combination. Uses glbalances for standard queries, gljelines when filtering by journal source/category or using JED balance… |
| 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… |
| 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… |
| GL Code Combinations | Parameter ‘Show Misclassified Accounts’ can be used to identify code combinations, which have a different account type than their flexfield value setup. There… |
| GL Daily Rates | Daily currency conversion rates |
| 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… |
| GL FSG Reports | Financial Statement Generator reports |
| GL FSG Row Orders | Financial Statement Generator row order listing |
| GL Financial Statement and Drilldown (FSG) | The GL Financial Statement and Drilldown (FSG) Report empowers users to generate comprehensive reports on financial balances while providing detailed insights… |
| GL Header Categories Summary | Master data report showing ledger, category and source definitions across multiple ledgers. |
| GL Journals | GL batches and journals report, including amounts and attachments. One row per journal line. The Knocked Off flag marks journal lines whose equal and opposite… |
| GL Journals (Drilldown) 11g | GL batches and journals report, including amounts and attachments.This report is used by the GL Financial Statement and Drilldown report, to show subledger… |
| GL Journals 11i | GL batches and journals report, including amounts and attachments |
| GL Ledger Sets | Master data report showing GL ledger sets and included ledgers. |
| 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. |
| GL Ledgers and Organizations | Master data report showing business group, ledger set, ledger, ledger category, currency, chart of accounts name, operating unit, organization code, country… |
| GL Oracle FSG Converter | This report is used by the GL Financial Statement and Drilldown report, to migrate financial statement reports from Oracle FSG. The GL Oracle FSG Converter is… |
| GL Oracle FSG Converter 11g | This report is used by the GL Financial Statement and Drilldown report, to migrate financial statement reports from Oracle FSG. The GL Oracle FSG Converter is… |
| GL Period Status | Accounting period status of all application modules for all or a selected list of ledgers, operating units and inventory organizations. To see if an accounting… |
| GL Periods | Geleral ledger calendars and accounting periods |
| GL Recurring Journal and Budget Formulas | Lists Oracle General Ledger recurring journal and budget formula definitions - batches, journal entries, lines and each line’s formula steps - with the account… |
| GL Summary Templates | Master data report showing GL summary and concatenation templates based on ledger, company, department, account, sub-account, and product segments, and… |
| GL Trial Balance - Detail | Imported from Concurrent Program Description: Detail Trial Balance (XML) Application: General Ledger Source: Trial Balance - Detail (XML) Short Name: GLTRBALD… |
| 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… |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH