OPP Manager: Trobleshooting

This is one of the crucial manager in Oracle concurrent managers. This helps converting output into other formats [ pdf etc ] . 

Few tips to get logfiles:

1. OPP Manager log files will be located under $APPCSF/$APPLLOG/*OPP*txt
    check the logs and you will know exact error.
2. If particular requests are failing use following SQL to check if that is template issue

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;

Please do asks questions if you want to know more on this. I am here to share what ever I know.