Configuring Oracle E-Business Suite on Oracle Cloud Infrastructure Classic with Oracle SOA Cloud Service Using the EBS Cloud Admin Tool


Options



Before You Begin

Purpose

In this tutorial, you will learn how to automate the configuration of Oracle E-Business Suite on Oracle Cloud Infrastructure Classic with Oracle SOA Cloud Service (PaaS) by using the EBS Cloud Admin Tool.

Time to Complete

About 25 to 30 minutes

Background

Oracle SOA Cloud Service provides a complete set of service infrastructure for designing, deploying, and managing composite applications in the cloud. These composite applications include Oracle E-Business Suite Adapter partner links that can connect to an Oracle E-Business Suite database running on Oracle Cloud. This tutorial describes how to use the EBS Cloud Admin Tool to create an Oracle E-Business Suite Adapter connection factory and the associated data source in Oracle SOA Cloud Service pointing to an existing Oracle E-Business Suite database running on Oracle Cloud.

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 the EBS Cloud Tools.

Note: The implementation of this configuration flow currently supports configuring a single Oracle E-Business Suite Adapter connection factory per Oracle SOA Cloud Service.

Note: This integration is only applicable to an Oracle SOA Cloud Service with Oracle SOA Suite Release 12.2.1.2 or Release 12.1.3 instance and an Oracle E-Business Suite Release 12.2 environment on Oracle Cloud. A multi-node environment of Oracle SOA Cloud Service is not supported in this release.

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:

This integration certifies the following Oracle SOA Suite versions supported in Oracle SOA Cloud Service:

  • Oracle SOA Suite Release 12.2.1.2
  • Oracle SOA Suite Release 12.1.3

Oracle E-Business Suite Adapter delivered with Oracle SOA Suite is available as part of the Oracle SOA Cloud Service applications adapters.

What Do You Need?

To perform the steps in this tutorial, you need:

Process Overview

To automate the configuration of Oracle E-Business Suite on Oracle Cloud Infrastructure Classic with Oracle SOA Cloud Service, you must complete the following tasks:

  1. Validate SSH connectivity between an Oracle E-Business Suite environment and an Oracle SOA Cloud Service instance.
  2. Determine cloud service account details.
  3. Run the EBS Cloud Admin Tool.
  4. Select an Oracle E-Business Suite environment.
  5. Provide the required inputs.
  6. Review and confirm the configuration.
  7. Validate the configuration.

Validating SSH Connectivity Between an Oracle E-Business Suite Environment and an Oracle SOA Cloud Service Instance

Before you start the configuration using the EBS Cloud Admin Tool, you must ensure that the SSH connectivity between your Oracle E-Business Suite environment and a desired Oracle SOA Cloud Service instance is in place.

  1. Ensure that you place the SSH public key of the EBS Cloud Admin Tool VM oracle user in the authorized keys file for the opc user in Oracle SOA Cloud Service.

    For more information, refer to the Oracle by Example tutorial, Common Tasks for Oracle E-Business Suite on Oracle Cloud Infrastructure Classic.

  2. In the EBS Cloud Admin Tool VM, you should be able to execute the following command to access the Oracle SOA Cloud Service instance you specified.
    ssh opc@<SOACS Host> 

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 REST 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 on Oracle Cloud Infrastructure Classic to identify and record these account detals for later use.

  • Oracle Cloud Infrastructure Compute Classic Service Instance ID
  • Oracle Cloud Infrastructure Compute Classic REST Endpoint
  • Oracle Cloud Infrastructure Object Storage Classic REST Endpoint

Running the EBS Cloud Admin Tool

Note: If you have already deployed the EBS Cloud Admin Tool, you must ensure that it is updated to 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.

Perform the following steps to run the EBS Cloud Admin Tool:

  1. Log in to the EBS Cloud Admin Tool VM as the oracle user and run the following command:
    $ perl /u01/install/APPS/apps-unlimited-ebs/ProvisionEBS.pl 
  2. The "Provision Oracle E-Business Suite - Options" menu appears.

    ============================================
    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  
  3. To integrate Oracle E-Business Suite with Oracle SOA Cloud Service, choose option "3: Manage Environments".
  4. When prompted, enter your cloud service account details and cloud credentials on the "Provision Oracle E-Business Suite - Enter Oracle Cloud Credentials" screen:

    Note: On subsequent runs, the screen will show default values presented in brackets which coincide with values entered in the previous execution of the utility. If a response is left blank, the default value will be used.

    ================================================================== 
    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 data center. 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 :
    

Selecting an Oracle E-Business Suite Environment

Once you have successfully run the EBS Cloud Admin Tool with cloud credentials, you can select a desired Oracle E-Business Suite environment for integration with Oracle SOA Cloud Service.

Perform the following steps to identify an Oracle E-Business Suite environment for the integration:

  1. On the "Oracle E-Business Suite Manage Environments - Choose Environment" screen, select a desired Oracle E-Business Suite environment from the list as shown in the following example.
  2. ================================================================      
    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 the above list: 1
  3. When prompted for the "Oracle E-Business Suite Manage Environments" menu, choose option 4 to configure the integration.
  4. ============================================
    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
  5. On the "Integrations and Advanced Configurations - Enter Selection" screen, choose option 1 to integrate Oracle E-Business Suite with Oracle SOA Cloud Service.
  6. ============================================================
    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: 1 

    For information on procedures about option 2 and option 3, refer to the following Oracle by Example tutorials:

Providing the Required Input

To automate the configuration of integrating Oracle E-Business Suite with Oracle SOA Cloud Service, you need to provide required credentials to access the Oracle E-Business Suite environment that you specified earlier, as well as provide the Oracle SOA Cloud Service instance information that will be configured for this integration.

Providing the Oracle E-Business Suite Access Credentials

Perform the following steps to provide the credentials to access the Oracle E-Business Suite environment:

  1. On the "Oracle E-Business Suite SOA Integration - Enter EBS Details" screen, when prompted, enter appropriate values for the following parameters:
  2. =============================================================
    Oracle E-Business Suite SOA Integration - Enter EBS Details
    =============================================================
    
    Environment: myebsenv1
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    Enter APPS password for staged instance                         : <password>
    Re-enter APPS password for staged instance                      : <password>
    Enter ASADMIN password for Oracle E-Business Suite instance     : <password>
    Re-enter ASADMIN password for Oracle E-Business Suite instance  : <password>
    
  3. Continue to the next section to provide the Oracle SOA Cloud Service instance details.

Providing the Oracle SOA Cloud Service Instance Details

In addition to specifying the required credentials for Oracle E-Business Suite, you need to provide the Oracle SOA Cloud Service instance details for this integration:

  1. On the "Oracle E-Business Suite SOA Integration - Enter SOA Details" screen, enter appropriate values when prompted.
    =============================================================
    Oracle E-Business Suite SOA Integration - Enter SOA Details
    =============================================================
    
    Environment: myebsenv1
     
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    Enter SOA Public IP Address                       : xxx.xxx.xxx.xxx
    Enter SOA OS User Name                            : oracle
    Enter SOA OS Group Name                           : oracle
    Enter Full Path to SOA WebLogic Domain Home       : /u01/data/domains/<domain_name>
    Enter Full Path to SOA WebLogic Server Home       : /u01/app/oracle/middleware/wlserver
    Enter WebLogic Admin Server Port                  : 9071
    Enter WebLogic Admin Server User                  : weblogic
    Enter WebLogic Admin Server Password              : <password>
    Enter DataSource Name                             : ebsds 
    Enter DataSource JNDI Name                        : jdbc/ebsds  
  2. On the next screen when prompted, choose option "1: server" as the desired target type to deploy Oracle E-Business Suite.
    Enter the target type to deploy EBS code:
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    1: server
    
    Enter a valid choice: 1 

    Note: A cluster environment in Oracle SOA Cloud Service is not supported in this release.

  3. On the next screen, enter appropriate values when prompted:
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    Enter the SOA Server Name: soaserver1                           
    Enter the SOA Server Port: 9073
  4. On the next screen when prompted, select a desired option as the Oracle Weblogic Server connection protocol for the Oracle SOA Cloud Service instance.

    In this tutorial, select option 1.

    Select Oracle Weblogic Server connection protocol for SOA instance: 
    
    [Ctrl-B: Back, Ctrl-H: Main Menu]
    
    1: t3
    2: t3s
    
    Enter your choice from above list: 1

Reviewing and Confirming the Configuration

After entering required information, you are prompted to review the configuration details you have specified earlier before proceeding with the configuration.

==================================
EBS SOA Integration - Review
==================================

Environment: myebsenv1
 
[Ctrl-B: Back, Ctrl-H: Main Menu]

SOA Public IP                                     : xxx.xxx.xxx.xxx
SOA Host                                          : <hostname.domain>
SOA OS user name                                  : oracle
SOA OS group name                                 : oracle
SOA WebLogic domain home                          : /u01/data/domains/<domain_name>
SOA WebLogic home                                 : /u01/app/oracle/middleware/wlserver
WebLogic Admin Server port                        : 9071
SOA Server Port                                   : 9073
WebLogic Admin Server user                        : weblogic
SOA target type                                   : server
SOA Server Name                                   : soaserver1 
DataSource Name                                   : ebsds
DataSource JNDI Name                              : jdbc/ebsds  
EBS Environment Name                              : myebsenv
Weblogic connection protocol for SOA Instance     : t3
EBS Apps Public IP                                : xxx.xxx.xxx.xxx

================================================================================
  

=================================================
Proceed With Selected Action
=================================================
Environment: myebsenv1
[Ctrl-B: Back, Ctrl-H: Main Menu]
1: Yes 2: No Enter your choice from above list: 1 =================================================

Select option "1: Yes" to proceed with the creation of the configuration. If you do not want to proceed, select option "2: No" to exit the EBS Cloud Admin Tool.

Validating the Configuration

Once the creation process is complete, use the following steps to validate if the configuration is successfully created:

  1. Log in to the Oracle SOA Cloud Service Console.
  2. Click the menu icon to open the Oracle WebLogic Server Administration Console.
  3. Enter Oracle WebLogic Server user name and password.
  4. In the Domain Structure tree, expand Services and then select Data Sources.
  5. In the Summary of JDBC Data Sources page, verify and ensure that the "ebsds" data source that we specified earlier using the EBS Cloud Admin Tool is created.

    This data source indicates the connectivity between the selected Oracle E-Business Suite environment and the specified Oracle SOA Cloud Service instance is successfully established through Oracle E-Business Suite Adapter.

Want to Learn More?

Change Log

Date Description
2019-04-19
  • Updated footer.
2018-06-29
  • Minor formatting enhancements.
2018-02-20
  • Changed "Determining Cloud Service REST Endpoints" to "Determining Cloud Service Account Details" and updated the content
  • Updated the following menu options:
    • Provision Oracle E-Business Suite - Options and Provision Oracle E-Business Suite - Enter Oracle Cloud Credential, from the Running the EBS Cloud Admin Tool section
    • Oracle E-Business Suite Manage Environments, Oracle E-Business Suite Manage Environments, and Integrations and Advanced Configurations - Enter Selection, from the Selecting an Oracle E-Business Suite Environment section
    • All menu options from the Providing the Oracle SOA Cloud Service Instance Details subsection
    • Proceed With Selected Action, from the Reviewing and Confirming the Configuration section
2017-11-08
  • Added the new section "Determining Cloud Service REST Endpoints".
2017-10-24
  • Updated product names and cross-referenced titles in Before You Begin, Process Overview, Run the EBS Cloud Admin Tool, Select an Oracle E-Business Suite environment, and Want to Learn More? sections.
  • Replaced Oracle SOA Suite version 12.2.1 with 12.2.1.2.
2017-09-27
  • Updated the "What Do You Need?" section.
  • Updated the following menu options:
    • Provision Oracle E-Business Suite - Options, Running the EBS Cloud Admin Tool section
    • Oracle E-Business Suite Manage Environments, Selecting an Oracle E-Business Suite Environment section
    • Oracle E-Business Suite SOA Integration - Enter EBS Details, Providing the Oracle E-Business Suite Access Credentials subsection
    • EBS SOA Integration - Review, Reviewing and Confirming the Configuration section
2017-08-15
  • Edited EBS Cloud Admin Tool screens with updated navigation options for 1.7.2 release.
  • Changed the "Enter SOA OS group name" parameter value to "oracle" in the Providing the Oracle SOA Cloud Service Instance Details section and the Reviewing and Confirming the Configuration section.
  • Updated the Background section.
2017-05-02
  • Updated the Running the EBS Cloud Admin Tool section.
2017-04-19
  • Updated table of available choices in the Background section with AD-TXK Delta 9.
2017-03-31
  • Updated table of available choices in the Background section.
2017-03-06
  • Updated step 2 in Providing the Oracle SOA Cloud Service Instance Details subsection, Providing the Required Input section.
2017-03-03
  • Updated links in What Do You Need? section, and Selecting an Oracle E-Business Suite Environment section.
2017-03-02
  • Initial publication.
Back to top