Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Supply Chain Analytics > Process of Configuring Siebel Supply Chain Analytics for Oracle 11i >

Configuring the Country Name

This task is a step in the Process of Configuring Siebel Supply Chain Analytics for Oracle 11i.

For Oracle 11i, you can reconfigure the region, state, and country names that apply to supplier locations only. By default, the Country Name column (EXT_COUNTRY_NAME) is populated using the same code value as the Country Code column (EXT_COUNTRY_CODE). However, you can redefine the load mapping's Source Adapter mapplet to load a source-supplied country name instead of the code. If you want to reconfigure the load in this manner, you can load the country code and country name into the IA_CODES table. For information on loading codes and code names into the IA_CODES table, see Codes Lookup.

When you have loaded the country code and country name into the IA_CODES table, you can remove the expression in the Source Adapter that defines the Country Name column. By setting the Country Name's expression to null, when the load occurs, the ADI looks up the country name in the IA_CODES table, using the supplied country code. The load mapping then inserts the country name and country code into the data warehouse table.

To configure the Country Name

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. Open the MPLT_SAI_SUPPLIERS mapplet.
3. Double-click the Expression transformation to open the Edit Transformations dialog box, and click the Port tab to display the EXT_COUNTRY_NAME port.
4. Edit the condition by removing the assigned value if you want the lookup to occur.
5. Click Apply.
6. Validate the mapplet, and save your changes to the repository.