My Oracle Support Banner

11i: Queries to Gather Data for a Journal from Tables GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES (Doc ID 1111848.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle General Ledger - Version 11.5.9 to [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.


Use these queries to gather data from GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES tables for a specific journal.

Please consider also running the following diagnostics:
- from Note 223712.1: Journal Data Collection Test.
- from Note 289773.1: Journal Activity Test.

a) If prompted for a user and responsibility you must enter the same as used in APPS.
b) Review Oracle General Ledger (GL) Diagnostics Catalog and Scripts Collection Document 1416402.1.
c) If you do not have Oracle Diagnostics installed, please ask your DBA to follow the instructions on Note 167000.1 for installing the diagnostic.
d) If needed you can check Note 341008.1 on how to use Oracle Diagnostics.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.