Oracle XML Bursting Control File - Sample

XML Format and group can be found from the View Requests Form/Diagnostics/View XML as follows:

Navigate XML Publisher Administrator/Home/Data Definitions
Click on "Create Data Definition" as highlighted


Under the XML Data Definition you will find the Bursting Control File option, Click on "Add File" button to upload the Bursting Control File as highlighted:-

 

Following is a sample XML Bursting control file:

 Parameters : P_SERVER_NAME,P_FROM_EMAIL,

                   P_TO_EMAIL,XML_GROUP_KEY,P_FILE_NAME,

                   P_PRINTER_NAME,P_NUM_OF_COPIES

Note: select is the XML file which can be derived from "Diagnostics/View XML" from the SRS View Requests Form

<?xml version="1.0" encoding="UTF-8" ?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
  <xapi:request select="/SAMPLEDOC/SAMPLE_GROUP">
<xapi:delivery>
<xapi:email server=<P_SERVER_NAME> port="25" from=<P_FROM_EMAIL>>
<xapi:message id="123" to=<P_TO_EMAIL> attachment="true" subject="Sample Document report">
Please find attached output of Sample Document report
</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output-type="pdf" delivery="123">
<xapi:template type="rtf" location="xdo://<APP_SHORT_NAME>.<RTF Template Code>.en.US?getSource=true">
</xapi:template>
</xapi:document>
</xapi:request>
  <xapi:request select="/SAMPLEDOC/SAMPLE_GROUP">
  <xapi:delivery>
   <xapi:print id="PRINT" printer=<P_PRINTER_NAME> copies=<P_NUM_OF_COPIES> />
    </xapi:delivery>
     <xapi:document key=<XML_GROUP_KEY> output="/tmp/<P_FILE_NAME>.PDF" output-type="PDF" delivery="PRINT">
     <xapi:template type="rtf" location="xdo://<APP_SHORT_NAME>.<RTF Template Code>.en.US/?getSource=true"/>
      </xapi:document>
      </xapi:request> 
</xapi:requestset>

----------------------------------------------------------------------------------------------

If you need to ftp a concurrent program then you can use the following XML Bursting syntax:


<xapi:request select="/SAMPLEDOC/SAMPLE_GROUP">
  <xapi:delivery>
   <xapi:ftp id="FTPBOX" server="<Server IP>" user="<Unix User>" password="<Unix Password>" remote-directory="  </FTP_Sample_Directory>" remote-file="${File_Name}.xls">
   </xapi:ftp> 
  </xapi:delivery>
  <xapi:document output="<Output_File_Name>" output-type="<PDF/EXCEL>" delivery="123">  
  <xapi:template type="rtf" location="xdo://<APPL_SHORT_NAME>.<RTF Template Code>.en.US/?getSource=true"/>
   </xapi:document>   
</xapi:request>

----------------------------------------------------------------------------------------------
 Note:- XML Publisher data definition and template definition are stored in XDO tables. Following 
         are the details:-

Template Definition Source tables:

XDO_TEMPLATES_B
XDO_TEMPLATES_TL

Data Definition Source tables:


XDO_DS_DEFINITIONS_TL
XDO_DS_DEFINITIONS_B