Tuesday, 29 April 2014

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:

    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

    Via the Oracle Application Manager (OAM)

    Login to the application as SYSADMIN
    Responsibility: System Administration
    Function: Oracle Applications Manager –> Concurrent Managers
    Select the Output Post Processor Service and click on View Details
    Click on View Processes
    Select the Concurrent Process which was active during the time that the request ran
    Click on the Log button to open the Output Post Processor log file

No comments:

Post a Comment