OPP ISSUES

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;

-->This will give you REQ_ID NODE_NAME & LOGFILE_NAME

-->grep <reqid> $APPLCSF/$APPLLOG/FNDOPP*.txt