Analytics Catalog/Oracle Fusion ERP/General Ledger
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · GL

General Ledger reports

Every General Ledger report — logic, source tables, parameterized SQL, the data dictionary, a star-schema data model, and extraction patterns. 42 reports.

General Ledger data model

The module's conformed star — the fact every General Ledger report rolls up to, surrounded by the dimensions shared across the module. See the full General Ledger data model → — all star schemas, the model dictionary, use cases, and every bicc View Object this module exposes.

GL_CODE_COMBINATIONSconformedGL_LEDGERSconformedGL_JE_HEADERSconformedGL_JE_LINESconformedGL_JE_LINESfact · General Ledger grainAmount · Count
●— fact → dimension join

Reports

GL
Oracle Fusion GL Trial Balance Report
A trial balance for Oracle Fusion — every account's debit and credit balance by ledger as of a date, the start…
GL
Account Analysis Report
What made this account move this period, and which transactions are behind the balance?…
GL
GL Daily Rates
The daily currency conversion rates loaded in the general ledger — rate by currency pair, conversion type, and…
GL
Account Ledger by Account Greece Report
The Greek statutory account ledger — every posting to each general ledger account over a period, in date order…
GL
China Account Analysis Detail Report
The detailed account analysis Chinese statutory reporting expects — every voucher line behind each general led…
GL
France GL Extract for ETAFI Report
The general-ledger extract that feeds France's ETAFI statutory filing — trial-balance and journal data mapped …
GL
GL Balance Tracking for Licensing Contracts Report
Tracks general-ledger balances for a revenue stream by cost center, selling method, and currency over time — a…
GL
GL Detail by Budget Center with Project Detail
General-ledger detail by budget center with the project behind each line — every journal line by budget center…
GL
GL Journal Unposted Report
Every journal still unposted in a ledger — who entered it, its source, status, and amount — so the close team …
GL
General Ledger Report for China Secondary Ledgers
The general ledger as kept in the Chinese-GAAP secondary ledger — balances and movements for the secondary led…
GL
General Ledger Trial Balance Monthly Movements Report
A trial balance that shows each account's opening balance, the month's debit and credit movement, and the clos…
GL
Greece Daily Journal Book - Line Descriptions Report
The Greek statutory daily journal book — every journal posted, in date order, with line-level descriptions, in…
GL
Italian Journal Book Report
The Italian statutory journal book (Libro Giornale) — all accounting entries in strict chronological, sequenti…
GL
Journal Approval Audit History Report
The approval trail for journals — who submitted, who approved or rejected, and when — so finance can prove jou…
GL
Journal Entry Reversal Detail Report
Every reversed journal and its reversal — the original entry, the reversing entry, the reason, and the period …
GL
Journal Voucher Report for China Secondary Ledger Report
Journal vouchers for the Chinese-GAAP secondary ledger in the local voucher format — each voucher with its acc…
GL
Ledger Comparison Report
A side-by-side of two ledgers' balances — typically primary versus secondary or reporting ledger — lined up th…
GL
Libro Partitario Report
The Italian Libro Partitario — the detailed subsidiary ledger showing every movement per account and per count…
GL
Pending Transaction Detail Report
Subledger transactions that have been accounted but not yet posted to GL, in detail — source, amount, and acco…
GL
Revaluation Report
Revalues foreign-currency general-ledger balances to a period-end rate and books the unrealized gain or loss —…
GL
Spain SII Report
The Spain SII (Suministro Inmediato de Información) submission — issued and received invoice detail with VAT b…
GL
Unrealized Foreign Currency Revaluation Report
The unrealized gain or loss from revaluing foreign-currency balances to period-end rates — by account and curr…
GL
Unrealized Foreign Currency Revaluation Report - All revaluations
The all-revaluations view of unrealized foreign-currency gain or loss — every revaluation rule's accounts in o…
GL
Unrealized Foreign Currency Revaluation Report - Banks
The banks-only view of unrealized foreign-currency gain or loss — revaluation limited to bank and cash account…
GL
Vietnam Journal Voucher Report
The Vietnamese statutory journal voucher — each accounting voucher in the local format with accounts, amounts,…
GL
Yevmiye Defteri - Electronic
Turkey's electronic journal ledger (Yevmiye Defteri / e-Defter) — all journal entries in the GİB-mandated XBRL…
GL
General Ledger Trial Balance Report
Do total debits equal total credits, and which accounts hold the balances driving the financials?…
GL
General Ledger Account Details Report
Provides journal information to trace each transaction back to its original source, printing a separate page p…
GL
Account Analysis for Contra Account Report
Prints balances by account segment and a secondary segment, listing the contra account for each journal entry …
GL
Average Balance Audit Account Analysis Report
Displays the detail account activity behind aggregate and average balances, showing daily average balance info…
GL
Journals Report
Provides journal activity for a period or range of periods by balancing segment, currency, and account range, …
GL
General Journals Report
Provides journal activity for a given period or range of periods by balancing segment value, currency, and ran…
GL
Journals Batch Summary Report
Lists posted journal batches for a ledger, balancing segment, currency, and date range, with source, batch and…
GL
Journals Details Report
Provides field-by-field information about manually entered journals prior to posting, including all data enter…
GL
Journals Day Book Report
Provides posted journal entries and journal details chronologically by accounting date for a range of dates, j…
GL
Reconciled Transactions Report
Provides details of clearing-account journal lines that have been successfully reconciled by the automatic and…
GL
Unreconciled Transactions Report
Lists unreconciled clearing-account journal lines, including lines not yet subject to reconciliation, lines re…
GL
Journal and Transaction Details Report
Lists general ledger journals and subledger transaction activity with header, line, and distribution-level det…
GL
Trial Balance Report
Provides summarized actual account balances and activity by ledger, balancing segment, and account segment val…
GL
Trial Balance - Average Balances
Provides ending and average balances for selected accounts based on a specified effective date, in ledger curr…
GL
Balancing Segment Value Assignments Report
Reports the assignment of primary balancing segment values to legal entities and ledgers across accounting set…
GL
Chart of Accounts Mapping Rules Report
Provides the segment and account rules defined for a chart of accounts mapping, printing subsidiary account ra…