How to find the OPP log file using concurrent request ID

 

Use below query to find the OPP log file using 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;

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