BI Publisher bursting

Oracle BI Publisher (xml Publisher) pdf file bursting

You can use Oracle BI Publisher (E-Business suite XML Publisher) to generate report out in pdf format and send directly to the following source system using bursting API.

• Email
• Fax
• FTP
• Printer
• FileSystem

STEP 1: Define concurrent program for report with xml output.


STEP 2: Define Data definition using xml publisher administrator and upload bursting control file according to your requirement.

==================
Email control file
==================
<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"
    listener="oracle.apps.xdo.batch.SampleListener">
  <xapi:request select="/RAXINV/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE">
  <xapi:delivery>
    <xapi:email  server="Mail server"
                 port="25"
                 from="from email address" 
                 reply-to ="Reply to email address">
      <xapi:message id="Myemail" 
      to="guest@mymail.us.oracle.com" cc="guest@mymail.us.oracle.com" attachment="true" content-type="html/text"
subject="Your Invoice #${TRX_NUMBER} ${BILL_CUST_NAME}">Dear Sir/Madam,
Please find attached your invoice  <B> #${TRX_NUMBER} </B>
....
....
....
Regards
Account Receivables Manager
</xapi:message>
    </xapi:email>
  </xapi:delivery>
  <xapi:document key="${TRX_NUMBER}" output="${TRX_NUMBER}" output-type="pdf" delivery="Myemail">
    <xapi:template type="rtf" locale="" location="xdo://AR.RAXINV.en.US/?getSource=true" translation="" filter="">
    </xapi:template>
  </xapi:document>
  </xapi:request>
</xapi:requestset>


==============
FTP control file
==============

<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"
    listener="oracle.apps.xdo.batch.SampleListener">
  <xapi:request select="/RAXINV/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE">
  <xapi:delivery>
    <xapi:ftp id="Myftp"
          server="ftp address" 
          user="${ftp_user}"
          password="${ftp_password}"
          remote-directory="/output"
          remote-file="${${TRX_NUMBER}.pdf">
    </xapi:ftp>
  </xapi:delivery>
  <xapi:document key="${TRX_NUMBER}" output="${TRX_NUMBER}" output-type="pdf" delivery="Myftp">
    <xapi:template type="rtf" locale="" location="xdo://AR.RAXINV.en.US/?getSource=true" translation="" filter="">
    </xapi:template>
  </xapi:document>
  </xapi:request>
</xapi:requestset>

===============
Fax control file
===============
<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"
      listener="oracle.apps.xdo.batch.SampleListener">
  <xapi:request select="/RAXINV/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE">
  <xapi:delivery>
    <xapi:fax server="faxprintername">
     <xapi:number id="MyFax">fax number</xapi:number>
    </xapi:fax>
  </xapi:delivery>
  <xapi:document key="${TRX_NUMBER}" output="${TRX_NUMBER}" output-type="pdf" delivery="MyFax">
    <xapi:template type="rtf" locale="" location="xdo://AR.RAXINV.en.US/?getSource=true" translation="" filter="">
    </xapi:template>
  </xapi:document>
  </xapi:request>
</xapi:requestset>

===============
Printer control file
===============

<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"
    listener="oracle.apps.xdo.batch.SampleListener">
  <xapi:request select="/RAXINV/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE">
  <xapi:delivery>
    <xapi:print id="Myprinter"printer="Printer Name" copies="1" />
  </xapi:delivery>
  <xapi:document key="${TRX_NUMBER}" output="${TRX_NUMBER}" output-type="pdf" delivery="Myprinter">
    <xapi:template type="rtf" locale="" location="xdo://AR.RAXINV.en.US/?getSource=true" translation="" filter="">
    </xapi:template>
  </xapi:document>
  </xapi:request>
</xapi:requestset>

STEP 3: Upload report template using XML Publisher administrator responsibility.

Now you are ready to use bursting API to send report output to the target.

Visit for more information http://blog.optiosys.com/