Monthly Archives: April 2018

BURSTING CONCEPT IN XML PUBLISHER

Leave a reply

XML Bursting Control file is used to E-mail/FTP/FAX/PRINT etc., output •of the Report
<xapi:request select> tag tells busting engine , bursting should be done at the occurrence of which tag ?
<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