Home » Applications » Oracle Fusion Apps & E-Business Suite » Posted Journal Entry
Posted Journal Entry [message #246771] Thu, 21 June 2007 19:14 Go to next message
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 Go to previous message
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.
Previous Topic: Cash Management - Questionaire
Next Topic: Prepayment matched with PO
Goto Forum:
  


Current Time: Wed Jul 03 02:25:38 CDT 2024