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

Loading Oracle Applications R10.7 Data

This section explains how to initially load data from Oracle Applications R10.7 to the Siebel database. It provides step-by-step directions for creating Siebel organizations and inventory locations and loading Oracle product, discount, price list and account data from Oracle Applications.

Loading Operating Units and Inventory Organization from Oracle Applications

When you initially load data from Oracle Applications R10.7 to Siebel Applications, you must first load Operating Units 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 as Organizations

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

   This script registers all Oracle Operating Unit definitions with the Notification Table. The Oracle Receiver detects the new entries and loads them into the Siebel application.

2. Start the Oracle Receiver.

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

To load Oracle Inventory Organization Definitions into Siebel Applications as Inventory Locations

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

   This script registers all Oracle Inventory Organization definitions with the Notification Table. The Oracle Receiver detects the new entries and loads them into the Siebel application.

2. Start the Oracle Receiver.

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

Loading Items from Oracle Applications

After Siebel organizations and inventory locations are created, you can load products from the Oracle Applications R10.7. This process is summarized below.

To load Oracle products

1. At the SQL prompt, run this script:

   siebelgeneral107script_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 Oracle Item and loads all Products into Siebel Applications. The workflow for this process is explained in Product Inbound Workflow.

Loading Discounts from Oracle Applications

Next, load discount data from Oracle Applications R10.7 to Siebel Applications. This process is discussed as follows.

Mapping

Siebel Applications discounts are price breaks that map to Oracle Discount Lines and Price Breaks. A single Oracle discount can map to multiple Siebel discounts, one for each Oracle Discount Line Item.

Active Oracle Discount Lines for a particular date are pulled into Siebel Applications as Volume Discounts. This is necessary because a new Oracle discount line can be created for an item that already exists under the same discount for a different period.

Thus, a single item can exist more than once under the same discount but only one record is active at a time. On the Siebel side, there is a one-to-one relationship between a Price List Item and a discount in a Price List. Therefore, only one discount can be pulled for an item under a single price list. These mapping relationships are represented in the following table.

NOTE:  The standard mappings of the Siebel eBusiness Connector for Oracle support only Unit Volume Price Breaks.

To load Oracle Discounts

1. At the SQL prompt, run this script:

   siebelgeneral107script_notify_discount.sql

   This script inserts records into the Notification Table for all Oracle Discount Lines and the corresponding price breaks.

2. Start the Oracle Receiver.

   The Oracle Receiver invokes the Oracle Receiver Dispatch Workflow which calls sub-process Discount- Receive Oracle Discount and loads all Oracle Discounts into Siebel Applications. The workflow for this process is explained in Discount Inbound Workflow.

Loading Pricing Definitions from Oracle

Next, load Pricing definitions from Oracle Applications R10.7 to Siebel Applications.

Mapping

Oracle Pricing definitions are mapped to Siebel Price Lists with no Discounts attached to the Oracle Price List Items. Oracle Discounts are mapped to Siebel Price Lists with Discounts attached to the Oracle Price List Items. Oracle Price List Lines are mapped to Siebel Price List Items.

Active Oracle Price List Items for a specific date are pulled into the Siebel Application. The Siebel eBusiness Connector for Oracle does not support Oracle Price List Items that have attached pricing rules.

These price list items are not pulled into Siebel Applications because an item may exist only once under a price list in Siebel Applications. Differently, in Oracle a new price list line can be created for an item that already exists under the same price list, in a different time period. This way, only one record is active at a time. Because the same item can be added to the price list with different pricing rules, that item can exist more than once under the same price list. This is not allowed in Siebel Applications.

These mapping relationships are represented in the following table.

To load Oracle Price Lists

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

   This script inserts records into the Notification Table for all Oracle Discount Lines and the corresponding price breaks.

2. Start the Oracle Receiver.

   The Oracle Receiver invokes the Oracle Receiver Dispatch Workflow which calls sub-process Pricing - Receive Oracle Price List and loads all Oracle Discounts into Siebel. The workflow for this process is explained in Price List Inbound Workflow.

Loading Customer Data from Oracle Applications

Next, existing customer data is loaded from Oracle Applications R10.7 to 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 Oracle Applications R10.7 to 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.