Finding OPP Log File

[admin]

SELECT fcpa.concurrent_request_id request_id, PUBLISHER_RETURN_RESULTS,
fcp.node_name node_name, fcp.logfile_name logfile_path
FROM fnd_conc_pp_actions fcpa, fnd_concurrent_processes fcp
WHERE fcpa.processor_id = fcp.concurrent_process_id
-- AND fcpa.action_type = 6
AND fcpa.concurrent_request_id = 'XXXXXXXX;