Siebel Connector for Oracle Applications > Setting Up the Connector > Loading Oracle Applications Data >

Loading Oracle Applications Data

This section explains how to initially load data from an Oracle Applications database to the Siebel database. It provides step-by-step directions for creating Siebel organizations and inventory locations and loading Oracle product and account data from Oracle Applications. Each task involves running a SQL script and starting the Oracle Receiver to load the data. These activities are described next.

Loading Operating Units and Inventory Organization from Oracle Applications

When you initially load data from Oracle Applications to Siebel Applications, you must first load Operating Unit definitions and then load Inventory Organization definitions in order to maintain the referential integrity of other data that you will be loading. These activities are summarized below.

To load Oracle Operating Units into Siebel Applications

1. At the SQL prompt, run the script siebelgeneral11iscript_notify_org.sql.

   This script inserts records into the Notification Table identifying all Oracle Operating Units.

2. Start the Oracle Receiver.

   The Oracle Receiver automatically invokes the Oracle Receiver Dispatch Workflow which calls sub-process Organization - Receive Oracle11i Operating Unit and loads all Oracle Organizations into Siebel Applications. The workflow for this process is described in Organization Inbound Workflow.

To load Oracle Inventory Organizations into Siebel Applications

1. At the SQL prompt, run the script siebelgeneral11iscript_notify_invloc.sql.

   This script inserts records into the Notification Table identifying all Oracle Inventory Organizations.

2. Start the Oracle Receiver.

   The Oracle Receiver automatically invokes the Oracle Receiver Dispatch Workflow which calls sub-process InvLoc - Receive Oracle11i Organization and loads all Oracle Inventory Organizations into the Siebel application. The workflow for this process is described in Inventory Locations Inbound Workflow.

Loading Pricing and Discounts Definitions from Oracle Applications

Pricing and Discount integrations are not provided with Oracle Applications at this time. You can define custom integration points to achieve integration, or use the Siebel Enterprise Integration Manager to load the data. For more information, see Siebel Enterprise Integration Manager Administration Guide.

Loading Items from Oracle Applications

After Oracle Applications' Operating Units and Inventory Locations are loaded, you can load Item definitions from Oracle Applications. This process is summarized below.

To load Item Definitions

1. At the SQL prompt, run this script:

   siebelgeneral11iscript_notify_product.sql

   This script inserts records into the Notification Table for all Oracle Product Items.

2. Start the Oracle Receiver.

   The Oracle Receiver invokes the Oracle Receiver Dispatch Workflow which calls sub-process Product - Receive Oracle11i Item and loads all Products into Siebel Applications. The workflow for this process is described in Product Inbound Workflow.

Loading Customer Data from Oracle Applications

Next, existing customer data is loaded from Oracle Applications into Siebel Applications. Use the Siebel Enterprise Integration Manager to load the data. The Integration Manager is described in Siebel Enterprise Integration Manager Administration Guide.

Loading Orders from Oracle Applications

Finally, existing order data is loaded from the Oracle Applications into Siebel Applications. Here again, the Siebel Enterprise Integration Manager is used to load the data. The Integration Manager is described in Siebel Enterprise Integration Manager Administration Guide.