| Populating Request_Id Column of gl_je_batches [message #508448] |
Sat, 21 May 2011 06:46 |
 |
jamaru
Messages: 1
Registered: May 2011
Location: Mumbai
|
Junior Member |
|
|
Hi,
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,
l_entered_cr
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
