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

Part Number E37608-03
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

3 Installing Pre-Built Integrations

This chapter describes how to install pre-built integrations 11.4 and the Application Integration Architecture (AIA) release version (RV) 3.1.1 Process Integration Packs (PIP) and Direct Integrations (DI) that are delivered in this release using the AIA Pre-Built Integrations Installer.

This chapter includes the following sections:

3.1 Prerequisites

3.2 Using the Oracle AIA Pre-Built Integrations Installer

When you use the AIA Pre-Built Integrations Installer the following occurs.

  1. You see a welcome screen that lists prerequisites and information about how to begin the installation process.

    The following prerequisite system checks are performed:

    • Operating system certification

    • Recommended operating system packages

    • Kernel parameters

    • Recommended gilbc version

    • Physical memory

  2. You are prompted to enter the installation location.

  3. You see an installation summary, which includes directory details, disk space required and available, and a list of the applications that are installed.

    The list of applications include all the pre-built integrations and AIA RV 3.1.1 PIPs and DIs.

    For more information about the pre-built integrations and AIA RV 3.1.1, see Section 3.3, "Pre-Built Integrations 11.4 and AIA RV 3.1.1 PIPs and DIs Delivered in this Release"

  4. You can choose to save the Response file, which stores the values that you have input and are displayed on the installation summary page.

For detailed screenshots of the AIA Pre-Built Integrations Installer, see Appendix A, "AIA Pre-Built Integrations Installer Screens".

3.3 Pre-Built Integrations 11.4 and AIA RV 3.1.1 PIPs and DIs Delivered in this Release

The AIA Pre-Built Integrations Installer 11.4 is used to install pre-built integrations 11.4 and the individual 3.1.1 PIPs and DIs.

Caution:

The AIA Pre-Built Integrations Installer helps you install all of the pre-built integrations and AIA RV 3.1.1 PIPs and DIs that are delivered in this release. However it is important that you only configure and deploy the integrations that you are going to be using. Please see the individual integration chapters for instructions for configuring and deploying your integrations.

3.3.1 Pre-Built Integrations Delivered in this Release

The following Pre-Built Integrations are delivered in this release.

Communications Pre-Built Integrations

  • Oracle Communications Order to Cash Integration Pack for Siebel CRM, Oracle Communications Order and Service Management, and Oracle Communications Billing and Revenue Management 11.2

    • Oracle Communications Order to Cash for Siebel CRM, OSM, and BRM Pre-Built Integration option

    • Oracle Communications Order to Cash for Siebel CRM and BRM Pre-Built Integration option

    • Oracle Communications Order to Cash for Siebel CRM and OSM Pre-Built Integration option

    Caution:

    When choosing the Pre-Built Integrations to configure and deploy, you must only select one Oracle Communications Order to Cash Pre-Built Integration options that are listed.

  • Siebel CRM Integration Pack for Oracle Communications Billing and Revenue Management: Agent Assisted Billing Care 11.2 (Comms Agent Assisted Billing Care: Siebel CRM - BRM)

  • Oracle Communications Billing and Revenue Management Integration Pack for Oracle Business Suite: Revenue Accounting 11.1 (Comms Revenue Accounting: BRM - EBS)

Customer Master Data Management Pre-Built Integrations

  • Oracle Customer Master Data Management Integration Base Pack 11.1 (Customer MDM Base Pack)

  • Oracle Customer Master Data Management Integration Option for Siebel CRM 11.1 (Customer MDM: Siebel CRM)

  • Oracle Customer Master Data Management Integration Option for Oracle E-Business Suite 11.1 (Customer MDM: EBS)

  • Oracle Customer Master Data Management Integration Option for Oracle Communications Billing and Revenue Management 11.1 (Customer MDM: Comms BRM)

Product Master Data Management Pre-Built Integrations

  • Oracle Product Master Data Management Integration Base Pack 11.2 (Product MDM Base Pack)

  • Oracle Product Master Data Management Integration Option for Siebel CRM 11.2 (Product MDM: Siebel CRM)

  • Oracle Product Master Data Management Integration Option for Oracle E-Business Suite 11.2 (Product MDM: EBS)

  • Oracle Product Master Data Management Integration Option for Oracle Communications Billing and Revenue Management 11.2 (Product MDM: Comms BRM)

  • Oracle Product Master Data Management Integration Option for Oracle Communications Design Studio 11.2 (Product MDM: Design Studio)

Product Lifecycle Management Pre-Built Integrations

  • Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release 11.2 (Design to Release: Agile-EBS)

  • Agile Product Lifecycle Management Integration Pack for SAP: Design to Release 11.2 (Design to Release: Agile-SAP)

Utilities Pre-Built Integrations

  • Oracle Process Integration Pack for Oracle Utilities Field Work 11.1

  • Oracle Customer Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy 11.1 (Customer Data Synchronization for Oracle Utilities CCB and Siebel Energy)

  • Oracle Product Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy 11.1 (Product Data Synchronization for Oracle Utilities CCB and Siebel Energy)

3.3.2 AIA RV 3.1.1 PIPs and DIs Delivered in this Release

The following AIA RV 3.1.1 PIPs and DIs are delivered in this release:

  • Oracle Design to Release Integration Pack for Agile PLM for Process and Oracle Process Manufacturing (Design to Release: Agile PLM for Process - OPM)

  • Siebel CRM Integration Pack for Oracle Order Management: Order to Cash 3.1.1 (Order to Cash: Siebel CRM - EBS)

  • Siebel CRM Integration to Oracle Incentive Compensation 3.1.1 (Siebel CRM to OIC)

  • Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite 3.1.1 (Lead to Order: CRM OD - EBS)

  • Oracle Financial Operations Control Integration Pack for Oracle Retail Merchandise Operations Management and PeopleSoft Enterprise Financials 3.1.1 (Financials Ops Control: Oracle Retail - PeopleSoft)

  • Oracle Financial Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite 3.1.1 (LSP Financial Mgmt: OTM - EBS)

  • Oracle Order Management Integration Pack for Oracle Transportation Management, Oracle E-Business Suite, and Siebel CRM 3.1.1 (LSP Order Mgmt: OTM - EBS - Siebel CRM)

  • Oracle Driver Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite 3.1.1 (LSP Driver Mgmt: OTM - EBS)

  • Oracle Value Chain Planning Integration Base Pack 3.1 (VCP Integration Base Pack)

  • Oracle Project Portfolio Management Integration Pack for Primavera P6 and JD Edwards EnterpriseOne 3.1.1 (Project Portfolio Mgmt: Primavera P6 - JDE E1)

  • Oracle Serialization and Tracking Integration Pack for Oracle Pedigree and Serialization Manager and Oracle E-Business Suite 3.1.1 (Serialization and Tracking: OPSM - EBS)

3.4 How to Create Backups of your Customizations

This section discusses the key tasks that you must perform before you install the media pack or when you apply patches to your existing integrations:

3.5 Preinstallation Configuration

This section discusses the preinstallation configuration steps you must complete for each Pre-Built Integrations or AIA R.V. 3.1.1 integration included in this release.

If your Pre-Built Integrations or AIA R.V. 3.1.1 integration is not mentioned in this section, it does not require preinstallation configuration.

3.5.1 Design to Release: Agile - EBS Pre-Built Integration

If Oracle E-Business Suite 12.1.x with PIM release is being used for integration installation, enable the Generate Item Number and Description Service in Oracle E-Business Suite. Before you enable this service, apply the required patches on Oracle E-Business Suite as mentioned in Chapter 2, "Software Requirements":

To enable the Generate Item Number and Description Service in Oracle E-Business Suite:

  1. Log in as SYSADMIN into Oracle Apps.

  2. Go to the Integrated SOA Gateway responsibility.

  3. Click Integration Repository.

  4. Select view-by as Interface Type.

  5. Navigate to Business Service Object, Discrete Manufacturing, Inventory Management.

  6. Click Generate Item Number and Description Service.

  7. Click Redeploy/Deploy Web Service.

    You can view Deployed WSDL URL under Abstract WSDL URL.

  8. Click the deployed WSDL link and verify whether WSDL is open. Also try accessing the imported schema location

    http://<host>:<port>/webservices/AppsWSProvider/oracle/apps/inv/ebi/item/GenerateItemNumberService.xsd. You should get the following message in the browser:

    "Return List Generated Item Number and Description"

    On View Source, the XSD should be visible.

  9. Provide Grant to the Integration User for this web service.

  10. Select the method getItemListNumberDescription and click Create Grant on the bottom of the page.

  11. Specify the user and click Apply.

    If there any issues, see the Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12 (ID 726414.1) and Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12 (ID 556540.1) on My Oracle Support [https://support.oracle.com].

3.5.1.1 Installing Variant Management

Variant Management is a patch for the Agile PLM 9.3 release. To use Agile PLM 9.3 with Variant Management for Design to Release: Agile - EBS / PIM Pre-Built Integration, you must install the patch before you run the AIA Pre-Built Integrations Installer.

Note:

The Variant Management Installer and the relevant documentation can be obtained from Oracle Software Delivery Cloud.

3.5.2 LSP Financial Mgmt: OTM - EBS PIP

Before you install the LSP Financial Mgmt: OTM - EBS PIP, ensure that "USERS" tablespace exists in the AIA database. You must create one if you do not find one.

To create a tablespace with the name "USERS" in the AIA database run the oracle database create tablespace command.

The following is a sample command to create the tablespace:

create tablespace users data file '[your file name]' size [file size]

For more details on creating tablespace see the Oracle DBA guide.

3.5.3 LSP Order Mgmt: OTM - EBS - Siebel CRM PIP

Before you install the LSP Order Mgmt: OTM - EBS - Siebel CRM PIP, ensure that "USERS" tablespace exists in the AIA database. You must create one if you do not find one.

To create a tablespace with the name "USERS" in the AIA database run the oracle database create tablespace command.

The following is a sample command to create the tablespace:

create tablespace users data file '[your file name]' size [file size]

For more details on creating tablespace see the Oracle DBA guide.

3.5.4 LSP Driver Mgmt: OTM - EBS PIP

Before you install the LSP Driver Mgmt: OTM - EBS PIP, ensure that "USERS" tablespace exists in the AIA database. You must create one if you do not find one.

To create a tablespace with the name "USERS" in the AIA database run the oracle database create tablespace command.

The following is a sample command to create the tablespace:

create tablespace users data file '[your file name]' size [file size]

For more details on creating tablespace see the Oracle DBA guide.

3.5.5 Value Chain Planning Integration Base Pack

Configure the following before installing Value Chain Planning (VCP) Integration Base Pack:

Table 3-1 Preinstallation Configurations

Item

Details

Database Schemas

Create database schemas.

Database schema must be available for the ODI master repository. Grant this schema appropriate permissions and privileges.

If you want a separate work repository for the VCP Base Pack Integration, create a second database schema for this purpose. Grant this schema appropriate permissions and privileges.

Environment variables

Set the %ODI_JAVA_HOME% to point to the JDK 1.6 installation directory. For example, %ODI_JAVA_HOME%=D:\Oracle\Middleware\Oracle_ODI1\jrockit-jdk1.6.0_17.

The path to JAVA_HOME should not contain spaces, such as "C:\Program Files\Java\jdk".

ODI Repositories

Create a master repository and connect it to the database schema.

Create a work repository and connect it to the database schema.


3.6 How to Install the Pre-Built Integrations and AIA RV 3.1.1 PIPs and DIs

To install the pre-built integrations and AIA RV 3.1.1 PIPs and DIs:

  1. Navigate to Oracle Software Delivery Cloud. [https://edelivery.oracle.com/]

  2. Select the Product Pack: Oracle Application Integration Architecture.

  3. Select your platform.

  4. Click Go.

  5. Click the Oracle Application Integration Architecture Pre-built Integrations Release 11.4 Media Pack link for your platform.

  6. Download the Oracle Application Integration Architecture Pre-built Integrations 11.4 Release file.

    Note:

    For more information on the downloads listed on this page, click Readme.

  7. Unzip the downloaded file.

  8. Navigate to aiapip/Disk1.

  9. Follow the launch instructions for your platform listed in the following table.

    Table 3-2 Launching the AIA Pre-Built Integrations Installer

    Platform To launch the AIA Pre-Built Integrations Installer:

    Linux x86

    Solaris SPARC (64-bit)

    IBM AIX Based Systems (64-bit)

    HP-UX 11i (64 bit)

    At the command line prompt, enter:

    ./runInstaller -invPtrLoc <AIA_HOME>/oraInst.loc -jreLoc <location of the jre specific to your operating system. This directory should have /bin/java>
    

    Microsoft Windows (32-bit)

    Double-click setup.exe


    AIA Pre-Built Integrations Installer launches Welcome screen.

  10. Click Next.

  11. Wait for the prerequisite checks to complete and then click Next.

  12. Select AIA Home where Foundation Pack is installed.

  13. Click Next.

  14. Review the installation summary. To save the Response file, click Save.

    The Response file stores the values that you previously entered and are on the summary page. If you want to do the install again, you can run a command and the AIA Pre-Built Integrations Installer performs a silent install with inputs from Response file instead of using the wizard.This is an example of the command. Observe the -silent and -response arguments.

    ./runInstaller -invPtrLoc /slot/ems4965/oracle/AIAHOME/oraInst.loc -jreLoc /slot/ems4965/oracle/Middleware/jdk160_24/jre -silent -response /slot/ems4965/oracle/11.1_Installer_response.xml
    
  15. If the information displayed on the summary page is correct, click Install.

    You can make changes before installing by selecting the topic you want from the pane on the left.

    A warning screen displays a message stating that the installation overwrites your customizations and asks you to create a backup before proceeding. For more information, see Section 3.4, "How to Create Backups of your Customizations".

    Click Yes to proceed with the installation.

  16. Click Next.

  17. To exit the AIA Pre-Built Integrations Installer, click Finish. The installation is complete.

  18. Verify whether PIPManifest.xml file exists under each PIP or DI folder under <AIA_HOME>/pips/<PIP Folder>/config. For example, <AIA_HOME>/pips/Communications/O2A/config.