Home » Applications » Oracle Fusion Apps & E-Business Suite » Populating Request_Id Column of gl_je_batches (Oracle R12 GL module)
Populating Request_Id Column of gl_je_batches [message #508448] Sat, 21 May 2011 06:46
Messages: 1
Registered: May 2011
Location: Mumbai
Junior Member
I am doing an inbound interface. In which gl_interface table is populated and then need to run import journals. This will populate tables such as gl_je_batches, gl_je_lines and gl_je_headers.
But conc. request_id column of gl_je_batches is not getting populated.
So any idea when it gets populated. Because using that request_id I need to do some validations.

SELECT SUM (c.entered_dr),
SUM (c.entered_cr)
INTO l_entered_dr,
FROM gl_je_batches b, gl_je_lines c, gl_je_headers h
WHERE b.request_id = l_request_id
AND b.je_batch_id = h.je_batch_id
AND h.je_header_id = c.je_header_id;

where I have l_request_id, but dont have request_id in gl_je_batches.
Previous Topic: E-business suite
Next Topic: costing hierarchy (need cost centre from assignment!)
Goto Forum:

Current Time: Fri Jul 30 12:16:11 CDT 2021