Configure Bursting Control file with Microsoft Cloud Email Account.

List of Topics (Linux, Database, RAC, EBS)

Configure (Salary Slip) Bursting File with Cloud Email Account(itinfocloudp)

Bursting to Email using SMTP over SSL/TLS Server Fails with Error "Must issue a STARTTLS command first" (Doc ID 2612866.1)

What Is The Recommended Location Of Xdodelivery.cfg or XDO.cfg In An R12.2 Environment? ( Doc ID 1915791.1 )

Email account has been changed from Local exchange server to Microsoft Cloud Exchange server: so need to update bursting control file accordingly and need to add xdodelivery.cfg in $XDO_TOP/resource directory as per the above docs.

Error in Bursting Log:

------------------------

451 5.7.3 STARTTLS is required to send mail [AM4PR0701CA0002.eurprd07.prod.outlook.com]

DEBUG SMTP: got response code 451, with response: 451 5.7.3 STARTTLS is required to send mail [AM4PR0701CA0002.eurprd07.prod.outlook.com]

RSET

DEBUG SMTP: EOF: [EOF]

com.sun.mail.smtp.SMTPSendFailedException: 451 5.7.3 STARTTLS is required to send mail [AM4PR0701CA0002.eurprd07.prod.outlook.com]

 

--------------------------------------------------------------------------------

BC file parameters for Cloud Email Acc. (pass same Email user entries in xdodelivery.cfg & Bursting File)

------------------------

<?xml version="1.0" encoding="windows-1256"?>

<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">

  <xapi:request select="/ListOfEmpDtls/EmpDtls">

    <xapi:delivery>

      <xapi:email id="GradeMsgId" server="smtp.office365.com" port="587" from="itinfocloudp@xxxx.com.sa">

        <xapi:message id="GradeMsgId" to="${ToEmailAddress}" cc="${CcEmailAddress}" attachment="true" content-type="text/html" subject="${EmailSubject}">

Dear Colleagues, 

Please be informed that your salary has been transferred to your bank account with the attached salary details.

المكرم الموظف المحترم / نفيدكم بأنه قد تم تحويل راتبكم الشهري  وذلك الى حسابكم البنكي،  و حسب التفاصيل المرفقة

 

</xapi:message>

      </xapi:email>

    </xapi:delivery>

    <xapi:document output="${AttchName}" output-type="pdf" delivery="GradeMsgId">

      <xapi:template type="rtf" location="/u01/OCI/fs1/inst/apps/ACIPDB_acapps3/appltmp/Salary_Template_Design.rtf"></xapi:template>

    </xapi:document>

  </xapi:request>

</xapi:requestset>

--------------------------------------------------------------------------------

 

 

 

--------------------------------------------------------------------------------

create xdodelivery.cfg with Cloud Email Account and password:

------------------------

[applmgr@acapps3 ~]$ cat $XDO_TOP/resource/xdodelivery.cfg

<?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.office365.com</host>

<port>587</port>

<secureConnection>tls</secureConnection>

<username>itinfocloudp@xxxx.com.sa</username>

<password>A@Ma5060dd0</password>

</server>

</servers>

<properties>

<property name="ds-temp-dir">/u01/OCI/fs1/inst/apps/ACIPDB_acapps3/appltmp</property>

<property name="ds-buffering">true</property>

<property name="SMTP_CONTENT_TYPE:String">"application/pdf"</property>

</properties>

</config>

[applmgr@acapps3 ~]$

--------------------------------------------------------------------------------

Data Definations

------------------------

XXAC_PAY_CASH_SLIP_XML

XXAC_PAY_SLIP_XML

XXAJR_PAY_SLIP_XML

 

--------------------------------------------------------------------------------

Salary Template file location (APPLTMP):

------------------------

[applmgr@acapps3 ~]$ ls -ltr $APPLTMP/Salary_*

-rw-r--r--. 1 applmgr oinstall 1272427 Apr 29 11:07 /u01/OCI/fs1/inst/apps/ACIPDB_acapps3/appltmp/Salary_Template_Design.rtf

-rw-r--r--. 1 applmgr oinstall 1314271 May  5 11:22 /u01/OCI/fs1/inst/apps/ACIPDB_acapps3/appltmp/Salary_Cash_Template_Design.rtf

--------------------------------------------------------------------------------

 

Thanks for Reading

Regards,

Mohammed Areefuddin.

Suggested Topics :

Linux	DATABASE	RMAN	RAC	EBS
5.7 Install	DATABASE Install		11201 Install	R1226 Install
Open Filer Instl	Active DataGaurd	Rman DataGuard	12102 RAC INSTAL	R1229 M7 Clone
DNS in Linux 7	WIN-LINUX MIGRATE	RMAN DB CLONE	RAC DataGuard	Pluggable DB Clone
lpadmin cups	ASMCMD ASM Migrt	RMAN ASM Migrt	RAC DB Clone	appsutil for DB
	11204 M-Upgrade		RAC - RAC Clone	JDK JRE upgrade
	12102 M-Upgrade		12C-19C RAC UPGRADE	Add EBS Node
	Flashback DB			ADOP in R12.2.9
				12102 EBS UPGRADE
Linux Basics	DATABASE Basics	RMAN Basics	RAC Basic	EBS Basics