Query To Find Concurrent Program OPP Service Log File Location On Server In Oracle APPS R12

If concurrent program ends in warning due to any OPP service failure, run below sql by passing request id :

SELECT fcpp.concurrent_request_id req_id, 
       fcp.node_name, 
       fcp.logfile_name 
FROM   fnd_conc_pp_actions fcpp, 
       fnd_concurrent_processes fcp 
WHERE  fcpp.processor_id = fcp.concurrent_process_id 
AND    fcpp.action_type = 6 
AND    fcpp.concurrent_request_id = <request_id>;