11i: Queries to Gather Data for a Journal from Tables GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES
Last updated on SEPTEMBER 16, 2016
Applies to:Oracle General Ledger - Version 11.5.9 to 188.8.131.52 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 13-May-2013***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms