Unposted GL journals
Returns journals that exist in the system but have not yet been posted to balances. Indicates close-readiness and stale entries.
Tables used
gl_je_headers gl_ledgers gl_je_sources_tl gl_je_categories_tl
Bind parameters
Supply values for :period_name when you run it.
How to run it
Paste it into a BI Publisher data model as a SQL data set, or into QueryWell's Query Studio and run it against your pod with a reporting account. Results come back to a grid you can profile, chart and export with a SHA-256 hash.
SELECT jh.je_header_id, jh.name AS journal_name, led.name AS ledger_name, jh.period_name,
src.user_je_source_name AS source, cat.user_je_category_name AS category,
jh.status, jh.running_total_dr, jh.running_total_cr, jh.creation_date, jh.created_by
FROM gl_je_headers jh
JOIN gl_ledgers led ON led.ledger_id = jh.ledger_id
JOIN gl_je_sources_tl src ON src.je_source_name = jh.je_source AND src.language = USERENV('LANG')
JOIN gl_je_categories_tl cat ON cat.je_category_name = jh.je_category AND cat.language = USERENV('LANG')
WHERE jh.status = 'U' AND jh.period_name IN (:period_name)
ORDER BY jh.creation_date DESCA single read-only SELECT against Oracle Fusion Cloud's supported reporting surface. Column names and views can differ by release and by the roles your reporting account holds, so validate the result against a report you already trust before relying on it.
gljournalsunpostedclose
More General Ledger queries
GL period status by ledger
Lists all GL accounting periods per ledger with their open/closed status. Use to confirm month-end close is complete before running trial balance.
Reversed journals last 90 days
Journals that have been reversed — common in error correction, but spikes can indicate process issues.
Trial balance — natural account totals
Aggregates posted activity per natural account for a given ledger and period. Confirms feed of subledger to GL.
Journal count and amount by source (period)
Journal volume and debit/credit totals grouped by source and category for a period. Quick feel for where postings originate (Manual vs subledger feeds).
Run it without the template cycle
QueryWell runs this and 81 other curated scripts against your own Fusion pod from one signed desktop app — grid, charts, profiling and hashed exports included. Perpetual licence, 14-day trial.