Query :
select sess.sid, sess.sql_hash_value, oracle_process_id OS_PROCESS_ID, fusr.description user_name , fcp.user_concurrent_program_name progName, to_char(actual_Start_date,'DD-MON-YYYY HH24:MI:SS') StartDate, request_id RequestId, (sysdate - actual_start_date)*24*60 ETime_in_Mins from apps.fnd_concurrent_requests fcr, apps.fnd_concurrent_programs_tl fcp, apps.fnd_user fusr, v$session sess where fcp.concurrent_program_id = fcr.concurrent_program_id and fcr.program_application_id = fcp.application_id and fcp.language = 'US' and fcr.phase_code = 'R' and fcr.status_code = 'R' and fcr.requested_by = fusr.user_id and fcr.oracle_session_id = sess.audsid (+) -- and p.addr = sess.paddr order by 6 DESC
Comments
Tags: Application DBA, APPS DBA, Concurrent Manager Jobs in Oracle Application, Disable Concurrent Manager Jobs, Disable Concurrent Manager Jobs in Oracle Application, ebs dba, Enable Concurrent Manager Jobs, Enable Concurrent Manager Jobs in Oracle Application, Oracle Application DBA, Oracle Application EBS Find Where Concurrent Manager Jobs Is On, Oracle APPs DBA, Oracle DBA, Other Ways To Take Concurrent Manager Jobs in Oracle Application