Friday 23 May 2014

xml bursting example in oracle apps

<?xml version="1.0" encoding="UTF-8" ?>
 <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">        
    <xapi:request select="/ARXMLINV/LIST_G_ORDER_BY/G_ORDER_BY">
                <xapi:delivery>
                   <xapi:email server="localhost" port="25" from="deepsan17@gmail.com" reply-to="noreply@gmail.com">
                   <xapi:message id="123" to="${CF_TEST_MAIL}" attachment="true" content-type="text/html" subject="Ar Invoice Report">                  
                   <![CDATA[
<html>
<body>
<p align="left">
<font face="Verdana" size="2" color="black">

Dear customer,<br><br>

Please find attached details of the latest AR Invoice ${TRX_NUMBER}.<br><br>

Regards,<br>
sss team <br><br>

<i>This is an auto-generated message. Please do not respond to this e-mail.</i> <br/>
____________________________________________________<br/>
</font>
 <font face="Verdana" size="2" color="green">
  <strong>Imagination at work </strong><br>
  <i><a>Support the go green initiative by not printing this email .. </a>
 </font>
</p>
</body>
</html>
]]>
                  </xapi:message>
                 </xapi:email>
                 <xapi:print id="print123" printer="ipp://1.1.1.1:9100/INVOICES" copies="1" />
                 </xapi:delivery>
                <xapi:document output="/erpeseg1/erpapp/comn/temp/Customer Invoice XML PRINT_${TRX_NUMBER}.pdf" output-type="pdf" delivery="print123">
                <xapi:template type="rtf" location="xdo://AR.ARXMLINV_US.en.US/?getSource=true" filter=""/>
            </xapi:document>
                <xapi:document output="/erpeseg1/erpapp/comn/temp/Customer Invoice XML Report_${TRX_NUMBER}.pdf" output-type="pdf" delivery="123">
                <xapi:template type="rtf" location="xdo://AR.ARXMLINV_US.en.US/?getSource=true" filter=""/>
            </xapi:document>
         </xapi:request>
      </xapi:requestset>

1 comment: