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 starting point for the close and the tie-out to the financial statements.

What the seeded report gives you

Trial Balance Report · OTBI subject area "General Ledger – Balances Real Time". Columns: Ledger, Period, Account, Beginning/Period Dr/Cr/Ending Balance, Currency, Balance Type.

Where it falls short

• Account-balance level only — no inline drill to the journal lines that built the balance.
• One ledger at a time; no native consolidated trial balance with eliminations.
• No prior-period or budget variance columns next to the balance.
• Limited segment pivoting; export caps; no retained history for trend.

What finance actually needs

• Drill: ending balance → journal line → subledger transaction → source document.
• Multi-ledger consolidated trial balance in one reporting currency.
• Prior-period, prior-year, and budget variance columns with % movement.
• Pivot by entity, cost center, or natural account without re-running.
• Reconciliation status + materiality flags; nightly snapshot reconciled to source.

Related  Same trial-balance question as the flagship General Ledger Trial Balance Report — this is the 'Oracle Fusion GL Trial Balance' name people search for.

Run note · BIP run  High-volume GL extracts can exceed BI Publisher's online output limit and time out. Run it as a scheduled process (ESS) with output bursted to file or email rather than online preview, and bound it by ledger and period.

SELECT  cc.concatenated_segments AS account, cc.account_description,
        b.begin_balance_dr - b.begin_balance_cr AS beginning_balance,
        b.period_net_dr AS period_debits, b.period_net_cr AS period_credits,
        (b.begin_balance_dr - b.begin_balance_cr) + b.period_net_dr - b.period_net_cr AS ending_balance
FROM    gl_balances b
JOIN    gl_code_combinations cc ON cc.code_combination_id = b.code_combination_id
WHERE   b.ledger_id = :ledger_id AND b.period_name = :period_name
  AND   b.currency_code = :reporting_currency AND b.actual_flag = 'A'
ORDER BY cc.concatenated_segments;