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 JUNE 10, 2019

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 June 2019***


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

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
Goal
Solution
 Still Have Questions?
References

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