Query to find PID from running concurrent request ID

 

Use below query to find PID of running concurrent request ID.

SELECT request_id,
TO_CHAR (ACTUAL_START_DATE, ‘DDMMYYYY
HH24:MI:SS’),
TO_CHAR (ACTUAL_COMPLETION_DATE, ‘DDMMYYYY
HH24:MI:SS’),
phase_code,
status_code,
os_process_id,
oracle_process_id
FROM apps.fnd_concurrent_requests
WHERE request_id = &req_id;

Thanks for going through the post.............