Concurrent Request Troubleshoot

Error message:
This request did not finish processing due to an unrecoverable error, and the concurrent manager that was running this request is no longer active.

Fix:
update apps.fnd_concurrent_requests set status_code='X', phase_code='C' where request_id in ('354904516','354904514','354904513','354904512','354904511');

Internal concurrent manager log file location:
Query:
SELECT 'ICM_LOG_NAME=' || fcp.logfile_name
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.manager_type = '0'
AND fcp.process_status_code = 'A';

Output:
'ICM_LOG_NAME='||FCP.LOGFILE_NAME
--------------------------------------------------------------------------------
ICM_LOG_NAME=/opt/sharetop/$TWO_TASK/fs_ne/comn/tmp/conc/system/log/$TWO_TASK_0409.mgr

Concurrent request log file:
SELECT logfile_name, outfile_name
FROM fnd_concurrent_requests
WHERE request_id = &1

Find the Conc Manager processing a request
Query:
select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a,
fnd_concurrent_queues_vl b, fnd_concurrent_requests c
where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID
and a.CONCURRENT_PROCESS_ID = c.controlling_manager
and c.request_id = <request_id>;

Output:
USER_CONCURRENT_QUEUE_NAME
--------------------------------------------------------------------------------
XXXX YYYYY Manager