Query to check currently running concurrent program in EBS R12.1.3

 

Login to apps user   sqlplus apps/<apps_passwd>   SELECT sess.sid,    sess.serial#,    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 * 60 ETime    FROM fnd_concurrent_requests fcr,    fnd_concurrent_programs_tl fcp,    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(+)    ORDER BY 8;