Siebel Connector for Oracle Applications > Setting Up the Connector >

Loading Oracle Applications Data


After the Siebel Connector for Oracle Applications is installed, the System Administrator must load Oracle Applications data into the Siebel database prior to using Siebel eBusiness Applications to capture orders. Follow the following sequence for the data load.

To load Oracle Application R10.7 data

  1. Load Operating Units definitions into Siebel Applications as Organizations.
  2. Load Inventory Organization definitions into Siebel Applications as Inventory Locations.
  3. Load Item definitions into Siebel Applications as Products.
  4. Load Discount definitions into Siebel Applications as Discounts.
  5. Load Pricing definitions into Siebel Applications as Price List.
  6. Load existing Customer data into Siebel Applications as Accounts.
  7. Load existing Order data into Siebel Applications as Orders.

Each time, you run a SQL script and start the Oracle Receiver to load the data.

To load Oracle Applications R11i data

  1. Load Operating Units definitions into Siebel Applications as Organizations.
  2. Load Inventory Organization definitions into Siebel Applications as Inventory Locations.
  3. Load Item definitions into Siebel Applications as Products.
  4. Load existing Customer data into Siebel Applications as Accounts.
  5. Load existing Order data into Siebel Applications as Orders.

Again, these tasks involve running a SQL script to register data from Oracle Applications' base tables with the Notification Table and starting the Oracle Receiver to receive the data. These activities are described in the next two sections.

Siebel Connector for Oracle Applications