How to get the Output Post Processor (OPP) logfiles

To investigate XML issues or other publishing problems, often the OPP log file is needed.

Below are the steps to find logfile 

1) From the Front end

• Login to the application as SYSADMIN  
• Responsibility: System Administrator
• Function: Concurrent –> Manager –> Administration
• Select the Output Post Processor
• Click on the Processes button
• Select the Concurrent Process which was active during the time that the request ran
• Click on the Manager Log button to open the Output Post Processor log file

2) If you know the request id and directly from the file system based after identifying the corresponding OPP log file name using the following SQL statement:

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;