Oracle BI Publisher reports: Issues and Debugging

Oracle BI Publisher reports: Issues and Debugging

Beginning post-processing of request 3181529 on node xtestL at 11-APR-2017 11:41:30.
Post-processing of request 3181529 failed at 11-APR-2017 11:41:31 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+
...

The actual error returned by the XML Publisher Core engine is captured in the OPP log file. There are three possible ways to obtain the OPP log file:

1. 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