Queries To Run To Gather Data For A Journal From Tables GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES - Release 11i

Queries To Run To Gather Data For A Journal From Tables GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES - Release 11i [ID 1111848.1]
		Modified 27-MAY-2010 Type HOWTO Status MODERATED

In this Document
Goal
Solution

---

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle General Ledger - Version: 11.5.9 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.

Goal

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

Solution

Upload the output of the following queries in a legible format(.xls file) so that all lines of data line up with their column headers.
Include the queries that you run so that we can see the parameters used.
Each tab of the spreadsheet file can have the results of one of the queries.

a.
Select *
from gl_je_batches
where set_of_books_id = &sob_id
and name = '&batch_name';

b.
Select *
from gl_je_headers
where je_batch_id = &je_batch_id -- returned in script a
and set_of_books_id = &sob_id;

c.
Select *
from gl_je_lines
where je_header_id = &je_header_id -- all returned in script b;

d.
SELECT kfv.concatenated_segments, gjl.*
FROM gl_je_lines gjl, gl_code_combinations_kfv kfv
WHERE gjl.code_combination_id = kfv.code_combination_id
AND gjl.je_header_id IN
(SELECT DISTINCT je_header_id
FROM gl_je_headers
WHERE je_batch_id = &JE_BATCH_ID);

Upload the queries and results, to the SR, in a formatted .xls file.


Hints:
-----
To find the set_of_books_id:
Help->Diagnostic->Examine.
Specify Block Name : HEADER and Field: SET_OF_BOOKS_ID


To find the batch id and header id:
Help->Diagnostic->Examine.
Specify Block Name : HEADER and Field:JE_BATCH_ID
Specify Block Name : HEADER and Field:JE_HEADER_ID

Related Products Oracle E-Business Suite > Financial Management > Financial Control and Reporting > Oracle General Ledger Keywords GL_JE_LINES; GL_JE_BATCHES; GL_JE_HEADERS

Back to top