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

Configuring the State Name

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

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 IA_CODES table. For information on loading codes and code names into the IA_CODES table, see Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse.

After you load the state code and state name into the IA_CODES table, you can remove the expression in the Source Adapter mapplet that defines the State Name column. If you set the State Name's expression to null, the ADI looks up the State Name in the IA_CODES table using the supplied state code, when the load occurs. The load mapping then inserts the state name and state code into the data warehouse table.

To configure the State Name definition

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 box, and select 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 to save changes.
6. Validate the mapplet, and click OK to exit.