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
----------------------------------------------------------------------------------------------------
<?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="
<xapi:message id="123" to="
</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
Good info Anil
ReplyDeleteThanks
Sreehari
Hi
ReplyDeleteNeed help
I want to add data in mail body not as attachment.
eg. Send mail to manager with all employee details.