Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring Supply Chain Analytics for Oracle 11i >

Configuring the Country Region and State Region Name

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

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

When you have loaded the region code and region name into the W_CODE_D table, you can remove the expression in the Source Adapter that defines the Region Name column. By making the Region Name's expression blank, the SIL looks up the Region Name in the W_CODE_D table, using the supplied region code when the load occurs. The load mapping then inserts the region name and region code into the data warehouse table.

To configure the Country Region Name

1. In PowerCenter Designer, open the Configuration for SDE_ORA1158_Adaptor folder.
2. Open the mapplet you want to edit. The following is a list of all Source Adapter mapplets that use the EXT_COUNTRY_REGION column:
   • mplt_SA_ORA_SupplierDimension
   • mplt_SA_ORA_BusinessLocationDimension_Plant
   • mplt_SA_ORA_BusinessLocationDimension_StorageLocation
3. Double-click the Expression transformation to open the Edit Transformations dialog box, and click the Port tab to display the EXT_COUNTRY_REGION 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.

To configure the State Region Name

1. In PowerCenter Designer, open the SDE_ORA115<Ver>_Adaptor.
2. Open the mapplet you want to edit.

   The following is a list of all Source Adapter mapplets that use the EXT_STATE_REGION column:

   mplt_SA_ORA_SupplierDimension

   mplt_SA_ORA_BusinessLocationDimension_Plant

   mplt_SA_ORA_BusinessLocationDimension_StorageLocation

3. Double-click the Expression transformation to open the Edit Transformations dialog box, and click the Port tab to display the EXT_STATE_REGION 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.