Friday 7 September 2012

Bursting in XML/ BI Publisher in Oracle Apps

The below one is the Control File for Bursting in XML/ BI Publisher
----------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
- <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
- <xapi:request select="/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE">
- <xapi:delivery>
- <xapi:email id="123" server="172.20.54.22" port="25" from="anilmca02@gmail.com" reply-to="">
<xapi:message id="123" to="anilmca02@gmail.com" cc="anilmca02@gmail.com" attachment="true" content-type="text/html" subject="test mail">Please review the attached document.</xapi:message>
</xapi:email>
</xapi:delivery>
- <xapi:document output="Invoice_${TRX_NUMBER}" output-type="pdf" delivery="123">
<xapi:template type="rtf" location="xdo://RTFLOCATION/?getSource=true" filter="" />
</xapi:document>
</xapi:request>
</xapi:requestset>
----------------------------------------------------------------------------------------------------
Replace the RTFLOCATION string with your RTF location using below query

SELECT APPLICATION_SHORT_NAME||'.'||
       TEMPLATE_CODE||'.'||
       DEFAULT_LANGUAGE ||'.'||
       DEFAULT_TERRITORY
       FROM XDO_TEMPLATES_VL
       WHERE TEMPLATE_CODE like 'WSHPURGE%'

Then update /tmp value in the XML publisher resp directory

XML publisher Admin Responsibility
         à Click on Administration
          à Then General 
            à Update /tmp value in  Temporary Directory

2 comments:

  1. Good info Anil

    Thanks
    Sreehari

    ReplyDelete
  2. Hi
    Need help
    I want to add data in mail body not as attachment.
    eg. Send mail to manager with all employee details.

    ReplyDelete