GL Trial Balance - Detail – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: General Ledger · all General Ledger reports
Overview
Imported from Concurrent Program Description: Detail Trial Balance (XML) Application: General Ledger Source: Trial Balance - Detail (XML) Short Name: GLTRBALD DB package:
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Ledger/Ledger Set, Ledger Currency, Currency Type, Entered Currency, Pivot Segment, Pivot Segment Low, Pivot Segment High, Period, Amount Type, Active Accounts Only, Show Parents, DFF Display, Secondary COA Mapping
Oracle EBS Tables Used
gl_ledgers, gl_ledger_set_assignments, gl_ledger_relationships, gl_balances, gl_code_combinations_kfv
Report Categories
Related Reports
GL Account Analysis, AP Accounted Invoice Aging, GL Account Distribution Analysis, AP Supplier Upload, GL Budget Amounts Upload, AR Customer Upload
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | GL Trial Balance - Detail - Trial Balance Pivot 19-Jul-2023 164357.xlsx |
| Blitz Report™ XML Import | GL_Trial_Balance_Detail.xml |
| SQL Source | GL Trial Balance - Detail.sql |
| Full Report on Enginatics | www.enginatics.com/reports/gl-trial-balance-detail/ |
GL Trial Balance - Detail - Case Study & Technical Analysis
Executive Summary
The GL Trial Balance - Detail report is a fundamental financial report that lists the balances of all General Ledger accounts, broken down by their individual segments (Company, Department, Account, etc.). Unlike a summary trial balance, this report provides the granular detail necessary for deep-dive analysis, period-end reconciliation, and audit verification. It serves as the primary “proof” that the books are in balance (Debits = Credits).
Business Use Cases
- Period-End Close: The primary tool used by accountants to verify that all subledger entries have been posted and that the trial balance nets to zero before closing the period.
- Account Reconciliation: Used to compare the GL balance of a specific account (e.g., “Accounts Payable”) against the corresponding subledger report (e.g., “AP Trial Balance”) to identify discrepancies.
- Audit Support: Provides external auditors with a complete listing of account balances at the end of the fiscal year.
- Variance Analysis: Allows analysts to compare balances across periods (if run for multiple periods) or to drill down into specific cost centers or departments.
Technical Analysis
Core Tables
GL_BALANCES: The primary source of data, storing the period-to-date and year-to-date balances for every code combination.GL_CODE_COMBINATIONS: Resolves the account segments.GL_LEDGERS: Defines the currency and chart of accounts context.- (XML Publisher Source): This report is often based on the standard Oracle XML Publisher data definition
GLTRBALD, which uses a package to extract data.
Key Joins & Logic
- Balance Calculation: The report aggregates
BEGINNING_BALANCE,PERIOD_NET_DR, andPERIOD_NET_CRfromGL_BALANCESto calculate theENDING_BALANCE. - Currency Handling: It handles “Entered” vs. “Accounted” currencies. For foreign currency accounts, it can show the balance in the original currency (e.g., EUR) as well as the functional currency (e.g., USD).
- Translation: If run for a translated currency, it uses the translated balances.
Key Parameters
- Ledger/Ledger Set: The entity to report on.
- Period: The specific accounting period.
- Currency: The currency to view (Functional, Foreign, or Translated).
- Amount Type: PTD (Period to Date) or YTD (Year to Date).
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