Skip Headers
Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations
Release 11.1

Part Number E23118-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

11 Configuring and Deploying Customer MDM: E-Business Suite

This chapter discusses how to configure and deploy the Oracle Customer Master Data Management Integration Option for Oracle E-Business Suite (Customer MDM: EBS).

This chapter includes the following sections:

11.1 Deployment Configuration Wizard

The DCW screens prompt you to enter the data required for successful configuration of Customer MDM: EBS. Enter the details of Customer MDM: EBS screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.

11.1.1 Integration Server Details Screen

All artifacts associated with the integration infrastructure components deploy to the integration server. This screen contains the following fields:

Table 11-1 Integration Server Details Screen Fields

Field Description

Admin Host Name

This is where the admin server resides. This can be a remote server or the same computer where the AIA Pre-Built Integrations Installer is launched. Example: server1.company.com.

The Admin Host Name is _________________________________

Admin Port

This is the port number on which Weblogic Admin server is started. To find this value contact WebLogic administrator. Example: 7001.

The Admin Port is _____________________________________

Domain Name

This is WebLogic server domain corresponding to the Admin Server. Example: domain1

The Domain Name is _____________________________________

Admin User Name

This value is the WebLogic admin user name. To find this value contact your WebLogic administrator.

The User Name is __________________________________

Admin Password

This value is the WebLogic admin password. To find this value contact your WebLogic administrator.

The password is _____________________________________

Managed Server

After you enter the Admin Host name, Admin Port, Domain Name, Admin user name and Admin Password, this field gets populated with managed servers for the domain. Select the manager server from the list. If you are deploying the integration to a SOA cluster, you should select the cluster name in this field.

The Managed Server is _______________________________

Managed Port

This field gets updated automatically after you select the managed server. If you have configured a SOA Cluster the SOA Cluster port appears in the list.


11.1.2 Oracle E-Business Suite Server Details Screen

Use this screen to enter details related to your Oracle E-Business Suite server instance. The screen contains the following fields:

Table 11-2 Oracle E-Business Suite Server Details Screen Fields

Field Description

E-Business Suite Host Name

This value is the fully qualified computer name of the Oracle E-Business Suite application. Example: example1.corp.example.com.

E-Business Suite Host Name is __________________________

E-Business Suite Port

This value is the Oracle E-Business Suite application port. To find this value, contact your administrator. Example: 8024.

E-Business Suite Port is ______________________________

E-Business Suite User Name

To find this value, contact your administrator.

E-Business Suite User Name is __________________________

E-Business Suite Password

To find this value, contact your administrator.

E-Business Suite Password is _________________________

Workflow Business Event System Name

This is the Workflow Business Event System Name of E-Business Suite Server. For example: SID.example.COM. To find this value, contact your administrator.

Workflow Business Event System Name is _________________

E-Business Suite Version

This is the version of the E-Business Suite Application. Valid value for the Customer Hub integration is 11.5.10, 12.1.1, 12.1.2 or 12.1.3. Other versions are not supported in the 3.1 release.


11.1.3 Oracle E-Business Suite Database Details Screen

Use this screen to enter details related to your Oracle E-Business Suite database instance. The screen contains the following fields:

Table 11-3 Oracle E-Business Suite Database Details Screen Fields

Field Description

E-Business Suite Database Host

This value is typically the computer name. To find this value, contact the database administrator. Example: server1.example.com.

E-Business Suite Database Host is ________________________

E-Business Suite Database Port

To find this value, contact the database administrator. Example: 1521.

E-Business Suite Database Port is _________________________

E-Business Suite Database Username

To find this value, contact the database administrator. Example: apps.

E-Business Suite Database Username is ____________________

E-Business Suite Database Password

To find this value, contact the database administrator.

E-Business Suite Database Password is ____________________

E-Business Suite Database SID (System ID)

To find this value, contact the database administrator. Example: orcl.

E-Business Suite Database SID is _________________________

Database Schema

To find this value, contact the database administrator. Example: server1. This field is optional for this integration.

Database Schema is __________________________________

Note: All the database credentials are used for creating the connection pool URL and data source URLs.


11.2 Overall Configuration and Deployment of MDM Customer Integrations

The overall MDM Customer integration consists of four component integrations: MDM Customer Base Pack (UCM) and three other options: MDM Customer Siebel, MDM Customer E-Business Suite and MDM Customer BRM. The overall MDM Customer integration can be configured and deployed by selecting any integration or integration combination. The configuration and deployment process consists of the following steps:

  1. Configure and deploy the MDM Customer component integrations. Section 11.3 discusses configuring and deploying the Customer MDM: EBS. For detailed instructions on the other MDM Customer integrations, see your specific integration chapters in Part I, "Configuring and Deploying Pre-Built Integrations" of this guide.

  2. Deploy the MDM Customer Routing Rules following the instructions discussed in Chapter 13, "Deploying Customer MDM Routing Rules". Routing Rules wire the integration services, depending on the integrations deployed.

  3. Configure and deploy the MDM Customer Match Fetch Enterprise Composite Application following the instructions in Chapter 14, "Deploying Customer MDM: Match Fetch Enterprise Composite Application". This UI application enables match and fetch of customers from the hub.

11.3 Configuring and Deploying Customer MDM: EBS

This section discusses the integration configuration and deployment process. There are two steps:

  1. Configure your integration using the DCW.

  2. Deploy the integration to the Fusion Middleware server.

11.3.1 Configure Customer MDM: EBS

The section discusses the configuration process. The screens that appear prompt you to enter the data that is required for successful configuration of Customer MDM: EBS. Keep the completed worksheets Customer MDM: EBS screens ready before you launch the DCW.

Note:

If you are harvesting content to OER, perform the first three steps. Else start from step 4.

To configure Customer MDM: EBS:

  1. Navigate to /slot/emsxxxx/oracle/Middleware/user_projects/domains/soa_domain/bin/ and open setDomainEnv.sh for Linux based systems and setDomainEnv.bat for Microsoft Windows.

  2. Replace WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false" with WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".

  3. Restart the server.

  4. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure installation environment.

  5. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh for Linux based systems and aiaconfig.bat for Microsoft Windows.

    This launches the AIA DCW.

  6. Click Next.

  7. Select Oracle Customer Master Data Management Integration Option for Oracle E-Business Suite under Customer Master Data Management Pre-Build Integrations

  8. Click Next.

11.3.1.1 Specify Integration Server Details

To specify integration server details:

  1. Enter information related to your integration server in the Integration Server Details screen.

  2. Click Next.

11.3.1.2 Specify Oracle E-Business Suite Server Details

To specify Oracle E-Business Suite Server details:

  1. Enter information about your E-Business Suite Server in the E-Business Suite Server Details screen.

  2. Click Next.

11.3.1.3 Specify Oracle E-Business Suite Database Details

To specify Oracle E-Business Suite Database details:

  1. Enter information about your Oracle E-Business Suite Database in the E-Business Suite Database Details screen.

  2. Click Next.

11.3.1.4 Complete Configuration

To complete configuration:

  1. Review the configuration information on the Configuration Summary screen.

    Note:

    If you want to make changes to the configuration, use the navigation pane on the left and select the screen you want to edit.

    You can create a response file based on the input provided in the DCW and use it in future when you want to deploy the integration. You can configure using the steps described in Section 11.3.2, "Configuring using the Response File". Click Save Response File and save the response file with the name and location of your choice.

  2. Click Configure to accept this configuration and begin the installation.

    The system displays progress of configuration in the Configuration Progress screen.

    The system displays any warnings or errors as necessary. You can review the configuration log for additional details. The configuration log location is displayed in Configuration Progress screen.

  3. When the configuration process finishes without errors, click Next.

  4. When the AIA DCW displays the Configuration Complete screen, click Finish to close the DCW.

11.3.2 Configuring using the Response File

To configure using the response file:

  1. Open the response file.

    When you create a response file through OUI, passwords get stored as <SECURE>.

  2. Replace the password fields with actual passwords in the response file.

  3. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  4. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh <Response File Location and Name> for Linux based systems and aiaconfig.bat <Response File Location and Name> for Microsoft Windows.

11.3.3 Deploying Customer MDM: EBS

To deploy the integration to Fusion Middleware server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Note:

    In Windows 2008, 2008 R2 and Vista, run the command prompt as an administrator (elevated mode). If the command prompt is invoked in normal mode, the integrations are not displayed.

    Table 11-4 Deployment Commands for Customer MDM: EBS

    Platform Deployment Command

    Linux x86

    Solaris SPARC (64-bit)

    IBM AIX Based Systems (64-bit).

    HP-UX 11i (64 bit)

    sh $AIA_HOME/pips/MDMCustomerEbiz/DeploymentPlans/deployMDMCustomerEbiz.sh
    

    Microsoft Windows (32-bit)

    %AIA_HOME%\pips\MDMCustomerEbiz\DeploymentPlans\deployMDMCustomerEbiz.bat
    

  3. Review the log file in the location specified in the command or at the default location <AIA_Instance>/logs/MDMCustomerEbizDP_Deployments_YYYY-MM-DD_HH-MI-SS.log to verify successful deployment of the integration.

Oracle AIA ships artifacts in AIA Lifecycle Workbench which can be used in your integrations. These artifacts are created using FMW technologies such as BPEL and Mediator and are natively supported by AIA Foundation Pack tools such as Project Lifecycle Workbench, Harvester, Deployment Generator, AIA Deployment Driver (ADD). These are called native artifacts and they include SOA artifact types such as composites, DataSources, DVM, xRef, and so on. These artifacts can be modified or new natively supported artifacts can be added using the AIA Lifecyle Workbench and a BOM.xml file can be generated.

AIA integration development teams, most often, also require deployment of artifact types that are beyond what is supported by the Project Lifecycle Workbench and AIA Harvester. For instance, integration may require artifacts such as, Java applications, Shell Scripts, ANT based build scripts which constitute part of integration landscape in addition to the artifacts that are delivered by AIA. AIA also supports deployment of these supplementary artifacts. However, you must modify and add new non native artifacts outside AIA Lifecycle Workbench.

For more information on deploying artifacts, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Generating Deployment Plans and Deploying Artifacts".

11.4 Verifying Deployment

To verify the Customer MDM: EBS deployment:

  1. Open the log files from the following location and look for warnings and error messages:

    • For Linux x86, Solaris SPARC (64-bit), HP-UX 11i (64 bit) and IBM AIX Based Systems (64-bit): Review the install log located at <AIA_HOME>/aia_instances/<instance name>/logs to verify whether the integration is successfully installed.

    • For Microsoft Windows (32-bit): Review the install log located at <AIA_HOME>\aia_instances\<instance name>\logs to verify whether the integration is successfully installed.

  2. Confirm that the Customer MDM: EBS processes were installed.

    1. Navigate to the Oracle Enterprise Manager Fusion Middleware Control: (http://<server name>:<port number>/em/).

    2. Log in with the server admin user name. For access details, contact the system administrator.

    3. Expand Farm_soa_domain, SOA, soa-infra, Default and look for the following items:

    • QueryCustomerPartyListEbizCreateAdapter

    • QueryCustomerPartyListEbizUpdateAdapter

    • QueryPersonAccountEbizCreateAdapter

    • QueryPersonAccountEbizUpdateAdapter

    • QueryResponsibilityEbizAdapter

    • SyncCustomerPartyListEbizAdapter

    • SyncCustomerPartyListEbizEventConsumer

    • SyncCustomerPartyListEbizProvABCSImpl

    • SyncCustomerPartyListEbizReqABCSImpl

    • SyncCustomerPartyListPersonEbizAdapter

    • SyncCustomerPartyListResponseEbizProvABCSImpl

    • SyncPersonAccountEbizEventConsumer

    • SyncPersonAccountEbizReqABCSImpl

    • TransformAppContextEbizService

For more information about the DVMs to be verified, see the Oracle Application Integration Architecture Customer Master Data Management Integration Pack Implementation Guide.

11.4.1 Validating Security Policies

All SOA composites are protected by Global Policies provided by Foundation Pack as defined in the Security section of the Developer Guide. Additionally individual services for this integration have locally attached security policies.

To validate locally attached security policies:

  1. Log in to Oracle Enterprise Manager Fusion Middleware Control

  2. Navigate to WebLogic Domain, soa_domain, Web Services, Policies.

  3. Verify Service Policy attachment.

    1. Find the service policy in the list of policies.

    2. Click the number in Attachment Count column.

      This opens Usage Analysis screen.

    3. Change the Subject Type list box to SOA Service.

    4. Validate that all the composites are listed with local attachment to this service policy.

  4. Verify Client Policy attachment

    1. Navigate back to Policies screen and find the client policy

    2. Click the number in Attachment Count column.

      This opens Usage Analysis screen.

    3. Change the Subject Type list box to SOA Reference.

    4. Validate that all the composites are listed with local attachment to this client policy and attached to the correct references.

      Table 11-5 Service Policy Attachments for Customer MDM: EBS

      Composite Service Policy

      TransformAppContextEbizService

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON


      Table 11-6 Saml Opt On Client Policy Attachments for Customer MDM EBS Pack

      Composite Reference Client Policy

      TransformAppContextEbizService

      AIAAsyncErrorHandlingBPELProcess

      oracle/aia_wss10_saml_token_client_policy_OPT_ON


For integration implementation, see Oracle Application Integration Architecture Customer Master Data Management Integration Pack Implementation Guide.

11.5 Undeploying Customer MDM: EBS

To undeploy the integration from Fusion Middleware Server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Table 11-7 Undeployment Command for Customer MDM: EBS

    Platform Undeployment Command

    Linux x86

    Solaris SPARC (64-bit)

    IBM AIX Based Systems (64-bit).

    HP-UX 11i (64 bit)

    sh $AIA_HOME/pips/MDMCustomerEbiz/DeploymentPlans/undeployMDMCustomerEbiz.sh
    

    Microsoft Windows (32-bit)

    %AIA_HOME%\pips\MDMCustomerEbiz\DeploymentPlans\undeployMDMCustomerEbiz.bat
    

  3. Restart the SOA server.

  4. Uninstall the integration following the instructions in Chapter 37, "Uninstalling Oracle AIA".