Hi gurus, Actually the request was completed 2 weeks back, Looking at the log file didnt help. is there a way to find the Machine, User etc information for the completed requests? Please advice. Thanks, Ananth On Wed, Apr 2, 2008 at 7:56 AM, Pravin RC <pravinrc@xxxxxxxxx> wrote: > If you have the concurrent request id you can browse the > fnd_concurrent_requests table and you will get complete details. > you can use the below query > > select * from fnd_concurrent_requests where > phase_code ='C' and > status_code='C' > request_id ='' > > On Wed, Apr 2, 2008 at 5:15 AM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote: > > > Hi all, > > > > I have to find machine/system information where the concurrent request > > was submitted. I have the requested ID which is Completed - Normal status. > > We can find the SID,serial# and related details from v$session in running > > session, but in the case of already completed request how do we find it?, Do > > we get any info of SID in con request log file and the machine name info > > from trace files, PLease correct me if i am wrong? Any ideas please suggest. > > > > > > Thanks, > > Ananth > > > > > > -- > Affectionately Yours > Pravin R C