Siebel Connector for Oracle Applications > Installing the Connector > Preliminary Requirements and Activities >

Software


The DBA or System Administrator must be certain that the following software is properly installed and configured before the Connector installation starts:

  • Oracle Applications R10.7 or Oracle Applications R11i (on the Oracle Database Server)
  • Oracle Client 8i software (on the Siebel Server)

    Oracle SQL*Net database connectivity software is installed during the client software installation. SQL*Net enables database messaging over a variety of network protocols.

  • Siebel Web Client software (on the Siebel Mobile Web Client or Siebel Dedicated Web Client if you plan to deploy these types of client)
  • ODBC drivers (on the Siebel Server)

See Siebel Server Installation Guide for directions on installing and configuring the Siebel Server and Siebel Gateway Server. See Siebel Web Client Administration Guide for directions on installing the Siebel Web Client. For descriptions of Oracle Applications installations, refer to the current Oracle Applications installation guide.

Installing and Configuring Oracle Applications R10.7 or R11i

Install Oracle Applications R10.7 or Oracle Applications R11i (English settings) on the Oracle Applications Server running Oracle/Windows NT. If you are running a different version of Oracle or Oracle in a different language or platform, ask your Systems Integrator for assistance in configuring your implementation. In addition, your Oracle system must include the latest database release, Oracle hot patches, and the Oracle kernel. For more information about these steps, see Siebel Server Installation Guide.

Enabling Account Outbound Integration

You must set up the conditions listed below before using the Account Outbound integration.

  • Add the Lookup Code GENERAL under the lookup type SITE_USE_CODE on the Oracle Side in the following screen.
    • For Oracle Applications R10.7:

    \Navigate\Setup\System\QuickCode\Receivables

    • For Oracle Applications R11i:

    \Navigator\Setup\System\QuickCode\Receivables

    The HQ site used for an address on the Siebel side will be mapped into the site use code GENERAL on the Oracle side.

  • Set Automatic Site Numbering to Yes in the following screen in the Oracle applications:
    • For Oracle Applications R10.7:

    \Navigate\Setup\Customers\Options\

    • For Oracle Applications R11i:

    \Navigator\Setup\Customers\System Options\Trans and Customers

    The flag is set in the Trans and Customers Tab.

    Next, click on \Zone\Next to go to the zone Customers. Then, set Automatic Site Numbering to Yes and save the screen. If it is not set to Yes, Location becomes a required column that is based on the Location. Site numbering is performed automatically.

  • County is a required column in the Sales Tax Location Flexfield. However, it is not a mandatory column in the Siebel database and is also not displayed in the User Interface (UI). For the Oracle Import program to pick up the County automatically for a particular state and city, it must be set up in the following screen. Otherwise, the Siebel application must pass the value for County in the following application:
    • For Oracle Applications R10.7: Navigate > Setup > Tax > Location.
    • For Oracle Applications R11i: Navigator > Setup > Tax > Location.
  • For Address Validation problem setup, navigate to Receivables > Navigate > Setup > System > System Options >Tax. Modify the Location Flexfield Structure. State County City is the default value. Change to State City, then SAVE.
Enabling Order Outbound Integration

In order to make the Accounts Receivable and Orders sent from Siebel Applications visible in Oracle Applications, you must perform the following setup before any user enters an Outbound Order.

To enable an outbound integration

  1. Create an Order Source Siebel (Siebel should be mixed case) in the following screen in the Oracle applications:
    • For Oracle Applications R10.7:

      Order Entry Super User \Navigate\Setup\Orders\Sources

      Name: Siebel (Type Siebel in the name field. If it was saved before, a warning message will appear.)

    • For Oracle Applications R11i:

      Order Source is created in \Navigator\Setup\Orders\Import Sources

  2. Set up the Operating Unit for both Receivables Super User and Order Entry Super User.
    1. Login as the System Administrator.
    2. Go to \Navigate\Profile\System.
    3. Select Responsibility as the level.
    4. For the Name, enter the name that will be used for Order Entry and Accounts Receivable.
    5. Check to be certain that MO: Operating Unit is not null and is the same for both the System Administrator and the Name that will be used for Order Entry and Accounts Receivable.

Installing the Siebel Web Client Application

To install the Siebel Web Client, follow the instructions provided in Siebel Web Client Administration Guide and perform the extra steps listed below.

To install the Siebel Web Client

  1. Go to the Windows Server application window.
  2. Go to the eappweb folder.
  3. Select and run install.exe.
Siebel Connector for Oracle Applications