1). finding the sid with request id == enter 10102224 select f.request_id,p.spid B_Process,s.sid,s.serial#,s.process F_Process,s.program, u.description from v$session s, v$process p, apps.fnd_concurrent_requests f, apps.fnd_user u where f.oracle_process_id = p.spid and p.addr=s.paddr and f.request_id=&request_id and f.requested_by = u.user_id; 2: Find sid status. select username,osuser,status,sid,serial#,last_call_et/3600,machine,to_char(logon_time,'DD-MM-yyyy HH24:MI:ss') from v$session where sid=59 select phase_code, status_code from apps.fnd_concurrent_requests where request_id=10102224; select phase_code, status_code from apps.fnd_concurrent_requests where request_id=10102226; select username,osuser,status,sid,serial#,last_call_et/3600,machine,to_char(logon_time,'DD-MM-yyyy HH24:MI:ss') from v$session where sid in ('4472','17811','1172','6722','7809','6715'); select phase_code, status_code from apps.fnd_conc...