Oracle Applications R12 Email Bursting 12.1.X, 12.2.X

[admin]

In this document, the following topics are covered and you can also watch the video explaining these topics,

1 XML Report Development
2 Get XML PATH
3 XML Bursting File
4 Temporary Directory
5 Protected PDF
6 FTP

In order to use GMAIL as email server here are a few steps,

Step 1) Apply Patch 28029438 BI-PUBLISHER 10G RE-HOSTING ROLL-UP PATCH FOR E-BUSINESS SUITE 12.2.X

Step 2) Edit your $XDO_TOP/resource/xdodelivery.cfg file to contain the following (replace username and password):

<?xml version="1.0" encoding="UTF-8" ?> 
<config xmlns="http://xmlns.oracle.com/oxp/delivery/config"> 
<servers> 
<server name="smtpserver1" type="smtp_email" default="true"> 
<host>smtp.gmail.com</host> 
<port>587</port>
<secureConnection>tls</secureConnection>
<username>XXXXXXX@gmail.com</username>
<password>XXXXXXXX</password>
</server> 
</servers> 
<properties> 
<property name="ds-temp-dir">/tmp</property> 
<property name="ds-buffering">true</property> 
<property name="SMTP_CONTENT_TYPE:String">"application/pdf"</property> 
</properties> 
</config>

ERPstuff Oracle Email Bursting R12.zip

Youtube video,

https://www.youtube.com/watch?v=Rk321RDGPNY

Thanks