Configuring Oracle Workflow Notification Mailer with Mail Servers for Oracle E-Business Suite on Oracle Cloud Infrastructure Classic Using the EBS Cloud Admin Tool


Options



Before You Begin

Purpose

In this tutorial, you will learn how to configure the Workflow Notification Mailer in an Oracle E-Business Suite instance on Oracle Cloud Infrastructure Classic with mail servers by using the EBS Cloud Admin Tool.

Time to Complete

  • A minimum of 20 minutes to complete the configuration and validation.

Background

The EBS Cloud Admin Tool automatically configures this integration for an environment created by either of the procedures described in the following Oracle by Example tutorials: Provisioning a New Oracle E-Business Suite Installation on Oracle Cloud Infrastructure Classic Using the EBS Cloud Admin Tool or Cloning Oracle E-Business Suite From On-Premises to Oracle Cloud Infrastructure Classic Using EBS Cloud Tools.

Your SMTP and IMAP mail servers can be located either on-premises or on Oracle Cloud.

We strongly recommend using an Oracle Cloud Virtual Private Network (VPN) solution when integrating with on-premises mail servers. For information regarding VPN options, see Oracle Cloud Infrastructure Networking Classic Offerings. If VPN is not used, then the on-premises mail servers must be made accessible to the Oracle E-Business Suite instance running on Oracle Cloud Infrastructure Classic using application security lists and security rules.

Certified Oracle E-Business Suite Release

The following release is certified for this integration:

Oracle E-Business Suite Release 12.2.3 or later, with the following patches:

What Do You Need?

To perform the steps in this tutorial, you need:

Process Overview

To configure mail servers for use with an Oracle E-Business Suite instance on Oracle Cloud Infrastructure Classic, you must complete the following tasks:

  1. Validate port connectivity between the Oracle E-Business Suite environment and the mail servers.
  2. Determine cloud service account details.
  3. Run the EBS Cloud Admin Tool to configure the Workflow Notification Mailer.
  4. Validate configuration was successful.

Validating Port Connectivity Between the Oracle E-Business Suite Environment and the Mail Servers

  1. Check that the appropriate port is enabled on the SMTP mail server to allow connections from the Oracle E-Business Suite environment. The default SMTP port is port 25.
  2. Check that the appropriate port is enabled on the IMAP mail server to allow connections from the Oracle E-Business Suite environment. The default IMAP port is port 143.

Determining Cloud Service Account Details

The EBS Cloud Admin Tool prompts you to enter cloud service account details, including the Compute Classic Service Instance ID as well as cloud service endpoints obtained when you provisioned your Oracle E-Business Suite instance.

Refer to the "Determine Cloud Service Account Details" section in the Oracle by Example tutorial Common Tasks for Oracle E-Business Suite in Oracle Cloud Infrastructure Classic to identify and record these account details for later use.

Running the EBS Cloud Admin Tool to Configure the Workflow Notification Mailer

In this section, you will use the EBS Cloud Admin Tool, ProvisionEBS.pl, to configure mail servers for use with your Oracle E-Business Suite environment.

Note: If you have already deployed the EBS Cloud Admin Tool, you must ensure it is on the latest codeline by following the instructions in section "Update EBS Cloud Admin Tool to Latest Codeline" of the Oracle by Example tutorial Deploying the EBS Cloud Admin Tool to Oracle Cloud Infrastructure Classic.

  1. Log on to the EBS Cloud Admin Tool VM you provisioned and switch from the opc user to the oracle user by running the command:
    $ sudo su - oracle
  2. Set your current directory to /u01/install/APPS/apps-unlimited-ebs/.
    $ cd /u01/install/APPS/apps-unlimited-ebs/
  3. Start the EBS Cloud Admin Tool by running the following command:
  4. $ perl /u01/install/APPS/apps-unlimited-ebs/ProvisionEBS.pl
  5. On the first screen, choose option "3: Manage Environments".

    ==============================================
    Provision Oracle E-Business Suite - Options
    ==============================================
    
    Provision Oracle E-Business Suite - Enter Selection:
    1:   Create New Environment
    2:   Create Environment from Backup
    3:   Manage Environments
    4:   Administer Orchestration VM
    5:   Manage Oracle Storage Cloud Service (OSCS) Backups
    6:   Clean Up After a Failed Provisioning 
    7:   Exit
    
    Enter your choice from above list: 3
  6. Next, enter your cloud credentials, including the cloud service REST endpoints obtained when you provisioned your Oracle E-Business Suite instance.

    The screen will show default values presented in brackets according to the values entered in the previous execution of the tool. If you do not enter a different response, the tool uses the default value.

    ============================================================
    Provision Oracle E-Business Suite - Enter Oracle Cloud Credentials
    ============================================================
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    Oracle Compute Cloud Service Endpoint [https://xxx.compute.us.oraclecloud.com] : 
    Oracle Storage Cloud Service Endpoint [https://xxx.storage.oraclecloud.com/v1/Storage-xxx] :
    Oracle Cloud Compute Service Instance ID [mycloudserviceid] : 
    Oracle Cloud Identity Domain [myclouddomain] : 
    Oracle Cloud Data Center Code (examples: em1, us2, ap3) [em1] :
    Oracle Cloud User Name [john.smith@example.com] :
    Oracle Cloud Password : <password>

    Note: The REST endpoints are used to identify the location of services at the site level within a datacenter. These endpoints are required in order to create the security artifacts associated with Oracle Compute Cloud instances (VMs). If the provisioning VM is located at a different site from your application tier VM (identified by the Compute Classic endpoint), you will be prompted to provide the provisioning VM REST endpoint, as seen below:

    Enter Oracle Compute Cloud Service Endpoint for Provisioning VM :
    
  7. Choose the Oracle E-Business Suite environment in which you want to configure the Workflow Notification Mailer.

    ================================================================
    Oracle E-Business Suite Manage Environments - Choose Environment
    ================================================================
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    Getting list of existing environments.
    1: myebsenv1
    2: myebsenv2
    
    Choose installation from above list: 1
    
  8. On the next screen, choose option "5: Configure Integrations".

    ===========================================
    Oracle E-Business Suite Manage Environments
    ===========================================
    
    Environment: myebsenv1
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    1:   Clone Environment
    2:   Scale Environment
    3:   Delete Environment
    4:   Manage Backups
    5:   Configure Integrations
    6:   Refresh EBS From Backup
    
    Enter your choice from above list: 5
    
  9. On the next screen, choose option "3: Configure Oracle E-Business Suite Workflow Notification Mailer".

    ===========================================================
    Integrations and Advanced Configurations - Enter Selection
    ===========================================================
    
    Environment: myebsenv1
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    1:   Integrate Oracle E-Business Suite with Oracle SOA Cloud Service
    2:   Integrate Oracle E-Business Suite with Oracle Access Manager (OAM)
    3:   Configure Oracle E-Business Suite Workflow Notification Mailer
    
    Enter your choice from above list: 3
    
  10. Next, enter the following details for the Workflow Notification Mailer configuration:

    • The fully qualified host name of the outbound SMTP mail server

    • The user name of the account that the notification mailer uses to connect to the SMTP server

    • The fully qualified host name of the inbound IMAP mail server

    • The user name of the account that the notification mailer uses to connect to the IMAP server

    • The address of the e-mail account that receives incoming messages, to which notification responses should be sent

    • The password for the account that the notification mailer uses to connect to the IMAP server

    • The password for the APPS user for your Oracle E-Business Suite environment

      Note: After you enter the APPS password, the tool prompts you to re-enter the password to confirm it.

    ===============================================================================
    Oracle Workflow Notification Mailer Basic Configuration - Enter Mailer Details
    ===============================================================================
    
    Environment: myebsenv1
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    Enter Fully Qualified Hostname of Outbound Mail Server : xxx.compute.oraclecloud.com
    Enter Outbound Email Account User Name : example@compute.oraclecloud.com
    Enter Fully Qualified Hostname of Inbound Mail Server : xxx.compute.oraclecloud.com
    Enter Inbound Email Account User Name : example@compute.oraclecloud.com
    Enter Inbound Email Reply-to Address : example@compute.oraclecloud.com
    Enter Inbound Email Account Password : <password>
     
    Enter APPS password for Oracle E-Business Suite environment: <password>
    
    Re-enter APPS password for Oracle E-Business Suite environment: <password>
    
  11. The next screen displays the configuration details you entered. Review your entries and enter option 1 to confirm that you want to proceed with the configuration.

    ===================================================
    Workflow Notification Mailer Configuration - Review
    ===================================================
    
    Environment: myebsenv1
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    Mailer Outbound mail server : xxx.compute.oraclecloud.com
    Outbound email account user name : example@compute.oraclecloud.com
    Mailer Inbound mail server : xxx.compute.oraclecloud.com
    Inbound email account user name : example@compute.oraclecloud.com
    Inbound email reply-to address : example@compute.oraclecloud.com
    Oracle E-Business Suite environment name : myebsenv1
    ===================================================
    
    =============================
    Proceed With Selected Action
    ============================= 
    
    Environment: myebsenv1
    
    [Ctrl-B: Back, Ctrl-H: Main Menu] 
    
    1: Yes
    2: No
    
    Enter your choice from above list: 1
    

    Note: If you do not want to proceed with the configuration as specified, enter option 2 to exit the tool. You can rerun the tool if necessary to specify different configuration details.

Validating the Configuration

If you want to validate the notification mailer configuration, you can optionally use the Advanced Notification Mailer Configuration Wizard in Oracle Workflow Manager to send test messages. See Test in the Oracle Workflow Administrator's Guide.

Want to Learn More?

Change Log

Date Description
2019-4-22
  • Updated footer.
2018-6-28
  • Made minor formatting enhancements.
2018-2-20
  • Replaced the Determining Cloud Service REST Endpoints section with the Determining Cloud Service Account Details section.
  • Updated the Running the EBS Cloud Admin Tool to Configure the Workflow Notification Mailer section to reflect new menu prompts.
2017-11-8
  • Updated product names and cross-referenced titles in Before You Begin, Process Overview, Running the EBS Cloud Admin Tool to Configure the Workflow Notification Mailer, and Want to Learn More? sections.
  • Added Determining Cloud Service REST Endpoints section and added a corresponding step in the Process Overview section.
2017-09-27
  • Added updates for navigation options and headings shown in EBS Cloud Admin Tool screens.
  • Added requirement for agent listeners in What Do You Need? section.
2017-08-15
  • Added updates for navigation options and headings shown in EBS Cloud Admin Tool screens.
  • Updated Background section.
2017-05-02
  • Added note regarding updating to latest codeline in Running the EBS Cloud Admin Tool to Configure the Workflow Notification Mailer section.
2017-04-19
  • Updated table of available choices in Background section with AD-TXK Delta 9.
2017-03-31
  • Updated table of available choices in Background section.
2017-03-03
  • Updated links in What Do You Need? section.
2017-03-02
  • Initial publication.