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 State 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 that apply to the Supplier locations only. By default, the State Name column (EXT_STATE_NAME) is populated using the same code value as the State Code column (EXT_STATE_CODE). However, you can redefine the load mapping's Source Adapter mapplet to load a source-supplied state name instead of the code. If you want to reconfigure the load in this manner, you can load the state code and state 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 state code and state name into the W_CODE_D table, you can remove the Expression in the Source Adapter that defines the State Name column. By setting the State Name's expression to null, the SIL looks up the state name in the W_CODE_D table using the supplied state code, during the load process. The load mapping then inserts the state name and state code into the data warehouse table.

To configure the State Name

1. In PowerCenter Designer, open the SDE_ORA115<Ver>_Adaptor.
2. Open one of the following mapplets:
   • 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_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.