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 SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 11.5.9 to 11.5.10.2 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 13-May-2013***


Goal

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.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms