Bookshelf Home | Contents | Index | PDF |
Siebel Connector for Oracle Applications > Setting Up the Connector > Loading Oracle Applications Data > Loading Oracle Applications R10.7 DataThis 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 ApplicationsWhen 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
To load Oracle Inventory Organization Definitions into Siebel Applications as Inventory Locations
Loading Items from Oracle ApplicationsAfter Siebel organizations and inventory locations are created, you can load products from the Oracle Applications R10.7. This process is summarized below.
Loading Discounts from Oracle ApplicationsNext, load discount data from Oracle Applications R10.7 to Siebel Applications. This process is discussed as follows. MappingSiebel 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.
Loading Pricing Definitions from OracleNext, load Pricing definitions from Oracle Applications R10.7 to Siebel Applications. MappingOracle 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.
Loading Customer Data from Oracle ApplicationsNext, 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 ApplicationsFinally, 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. |
Siebel Connector for Oracle Applications |