Bursting Concept in XML Publisher

XML Bursting Control file is used to E-mail/FTP/FAX/PRINT etc.,the output •of the Report

1.<xapi:request select> tag tells busting engine , bursting should be done at the occurrence of which tag ? 


2.<xapi:delivery > tag tells bursting engine , which delivery mechanism to be used and on what condition ?

Steps for generating the output and processing it through XML Bursting file.

Depending up on the source for generating the XML Data structure required for the XML Report

• Build the Data Logic as per the business requirements
• Below is sample code needs to be called from plsql code or after report trigger of Oracle Reports builder
  v_bursting_request_id := APPS.FND_REQUEST.SUBMIT_REQUEST('XDO',
          'XDOBURSTREP',
          NULL,
          NULL,
          FALSE,
          'Y',
         V_req_id, --Parent program’s request id
         'Y');  
   
• Deploy the data logic to the server
• Register the concurrent Executable
• Register the Concurrent program with output type as 'XML'
• Assign the Concurrent program to the Required Request Group
• Run Concurrent program and it will generate the output as XML file
• Using the XML file generated above, Build the layout as RTF for the data structure using MS-Word(Template builder should have been installed in the machine,which will show as a add on in the Ms-Word)
• Build the Bursting Control File by considering the XML tags generated
• Below are various Delivery mechanisms
  
  
  •         To Email:
   <xapi:delivery>
        <xapi:email id="${CONC_REQUEST_ID}"  server="Test.server.com" port="22" from="${from email id source}" reply-to="">
         <xapi:message id="${CONC_REQUEST_ID}" to="${to email id source}" cc="" bcc="" attachement="ture" Subject="PO Report">Hi,
                 Please find the attached Purchase order report generated.TNX,${source name } </xapi:number>
             </xapi:email>
          </xapi:delivery>
  
  
  •         To FAX:
   <xapi:delivery>
        <xapi:fax  server="fax server">
          <xapi:number id="FAX1">"$fax number"</xapi:number>
        </xapi:fax>
   </xapi:delivery>
  
  
  
  
  •         To PRINT:
  <xapi:delivery>
   <xapi:print id="DELIVERY_PRINT"     printer=" printer path" copy-no="1" paper- size="letter"    orientation-requested="3" />
   </xapi:delivery>
  
  
  •         FTP Delivery:
       <xapi:ftp id="ftp_delivery" server="test.server.com" user="${user}" password="${password}"remote-
       directory="${RemoteDir}" remote-file="${EMPLOYEE_ID}.pdf" />
  
  
  •         SFTP Delivery:
  
  
  For SFTP delivery, there is one additional attribute “secure-ftp”.
  <xapi:ftp id="sftp_delivery" server=“test.server.com" user="${user}" password="${password}"remote-directory="${RemoteDir}" remote-file="${EMPLOYEE_ID}.pdf"  secure-ftp=”TRUE”/>
  
  
• Define the Data Definition using the XML Publisher responsibility
• Attach the Bursting Control file to the Data Definition
• Define the Template
• Submit the report

XML Reports are most used now a days because of their user friendly nature.