Posted Journal Entry [message #246771] |
Thu, 21 June 2007 19:14 |
smulukutla
Messages: 45 Registered: May 2006
|
Member |
|
|
Do you know which column stores who posted a journal entry?
I asssumed last_update_by in journal header table would have the info but it doesn't turn out to be case.
Thanks for your help,
|
|
|
Re: Posted Journal Entry [message #246981 is a reply to message #246771] |
Fri, 22 June 2007 13:20 |
tmax13
Messages: 18 Registered: June 2007 Location: Mumbai
|
Junior Member |
|
|
Give this a try.
GL_JE_BATCHES has a column called REQUEST_ID which should hold the conc request id of the 'Posting' process, that was responsible for the Posting of the batch. Use this request_id in FND_CONCURRENT_REQUESTS to find out who it was submitted by. If it was Posted by AutoPost, this will not help.
Regards
Thomas.
|
|
|