Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Customer-Centric Enterprise Warehouse for Oracle 11i >

About Adding Oracle Flex Fields to the Data Model

Oracle Applications have two kinds of flex columns:

• Key flex fields. Key flex fields are key fields that are required by Oracle 11i. You can modify their definitions when configuring Oracle Applications.
• Descriptive flex fields. Descriptive flex fields are extension fields in the Oracle Applications database.

Key Flex Fields

The Siebel Customer-Centric Enterprise Warehouse has prepackaged mappings to extract some of the key flex field data. However, if you configure any of these key flex fields other than the default configuration prepackaged by the Siebel Customer-Centric Enterprise Warehouse, you must modify the mappings. The following are the key flex fields preconfigured for extraction:

• GL Account, account segment only. If you want to incorporate any other segment, you must modify the extract and load mappings.
• Territory, segments 1, 2, and 3 only. These key flex fields are used for Business Organizations Sales Geographical hierarchies only. If you want to incorporate any other segments, you need to modify the extract and load mappings.
• Product Category, segments 1 and 2 only. These key flex fields are used for classification only. If you want to incorporate any other segments, you need to modify the extract and load mappings.

If you wish to add other key flex field data to the data model, it is recommended that you use the extension columns available in the tables. For more information on using extension columns, see Overview of Storing, Extracting, and Loading Additional Data.

Descriptive Flex Fields

The Siebel Customer-Centric Enterprise Warehouse prepackages different types of extension columns that you can use to hold any additional data. For more information on using extension columns, see Overview of Storing, Extracting, and Loading Additional Data.