My Oracle Support Banner

E-Business Suite Workflow Steps for Configuring Workflow Java Mailer for SSL using Sendmail SMTP/STARTTLS (Doc ID 1326217.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Workflow - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Purpose

E-Business Suite Workflow, Workflow Mailer Outbound Processing related issues

To give quick steps with example commands and tools to set up Workflow Java Mailer for SMTP with SSL using Sendmail and Stunnel or just Sendmail. 

It is to be understood that the tools referred to here are just examples of tools provided by other vendors, and Oracle does not give any recommendation on which tool to use or support their usability. 

It is recommended that before use any of the tools mentioned herein, do research on the web and elsewhere to gain a good understanding of the tools.

Scope

System Administrators, Security Administrators, Support Engineers and Implementation Consultants

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1) Generate a Certificate Signing Request (CSR) using openssl
 a) Generate Private Key
 b) Create a Certificate Signing request (CSR) that will be sent to a Certificate Authority
 2) Optionally Create a Self-Signed Certificate
 3) Installing the Private Key and Certificate on the SMTP Server.
 4) Configure Sendmail (version 8.13.0 or later) to do SMTPS itself without Stunnel.
 5) Generate sendmail.cf file once done with the changes:
 6) Restart sendmail service while connected to the operating system (OS) as the root user:
 7) Testing telnet SSL connection to the SMTP Server on default SSL port 465  
 8) (Conditionally Required) Load the local certificate authority's certificate (CA certificate) into a local trust store
 a) Copy certificate file to:
 b) Optionally, Create own trust store
 c) Importing the certificate into the trust store using keytool:
 9) (Conditionally required) Update java mailer trust store parameters MAILER_SSL_TRUSTSTORE using step 6 of <Note: 409026.1>
 10) Testing Java Mailer command line connection to SMTP Server
 11) Configure the rest of the Java Notification Mailer for SSL using Oracle Applications Manager Workflow Mailer Configuration Wizard.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.