2) How to Retrieve XML Publisher Report output

Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite.One can Design and control how the report outputs will be presented in separate template files,known as template.At runtime, XML Publisher merges designed template files with the report data to create a variety of outputs to meet a variety of business needs.

Basic Requirement

XML Publisher report generated through a concurrent program. The output of concurrent program merges the report data with the designed template.

Now our requirement is to get the concurrent output file and store the file in Database a clob/blob.

Pre-Requisite

Following are the pre-requisites for our solution approach

1) The XML Publisher report is configured and running as intended.

2) The user able to see the XML publisher report after successfull completion of Concurrent Program(OPP is running).

Solution Approach

First we will discuss about how we can see the concurrent program report output and the XML output

1) Report Output

The report can be viewed by clicking on the output button of the concurrent program.

Note:- If the output is not comming or comming as XML, then it may be because OPP is not running. Please get in touch with Database administrator team.Please ensure that

           there is no error in generating the data in XML format.

2) XML data Output

In XML Publisher data is formated in XML.To view the XML data generated via concurrent program we need to click on the Diagnostics button.(As shown below)

3) Retrieve XML output and store it in database

The XML output report/document are stored in $APPLCSF/$APPLOUT . The output file name is in the following format

<CONC_SHORT_NAME>_<REQUEST_ID>_<NO>.<Extension>

CONC_SHORT_NAME = This is the short name of concurrent program,given during the creation of concurrent program

REQUEST_ID              = Request_id of the concurrent program that generates the file

NO                              = Counter

Extension                     = Extension of the file can be RTF/PDF/HTML depends on output format chosen.