Friday, April 13, 2012

How to Debug – XML Publisher Report – Log

The Concurrent Request ends with Phase ‘Completed’ and Status ‘Warning’ which indicates that the Output Post Processor (OPP) failed to generate an output file. In such cases the request log file shows a generic error message indicating the the post-processing action has failed:
    +————- 1) PUBLISH ————-+
    Beginning post-processing of request 3181529 on node PBREUGEL at 11-APR-2008 11:41:30.
    Post-processing of request 3181529 failed at 11-APR-2008 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:

    * 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

    * Via the Forms application:

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

    * Via the Oracle Application Manager (OAM)

   1. Login to the application as SYSADMIN
   2. Responsibility: System Administration
   3. Function: Oracle Applications Manager –> Concurrent Managers
   4. Select the Output Post Processor Service and click on View Details
   5. Click on View Processes
   6. Select the Concurrent Process which was active during the time that the request ran
   7. Click on the Log button to open the Output Post Processor log file
Related Posts Plugin for WordPress, Blogger...