Configuring Siebel eBusiness Applications > Creating and Administering Lists of Values >

Determining If the Picklist Is Bounded

A bounded picklist is a picklist where users must choose from the existing choices and cannot enter their own data. An unbounded picklist is a picklist where users may either enter their own data or choose from the existing choices. Only bounded picklists can be configured to be multilingual.

You must verify that the picklist is bounded and that the underlying column has the Lov Bounded property set to True. All columns for a particular LOV type must be bounded. If any of the columns for the LOV type is not bounded, then none of the columns can be set to multilingual for that LOV type.

For example, Table 54 shows the columns for the LOV type AVAILABILITY_STATUS. Although three of the columns are LOV bounded, you would not be able to enable these columns as multilingual, because one column (NEXT_AVAIL_CD) is Unbounded. If you were to run the MLOV Upgrade Utility, you would receive an error message that says the columns are inconsistently bounded. For more information, see Resuming the MLOV Upgrade Utility When Errors Occur.

You can change the LOV Bounded and LOV Type properties of the column object in the following circumstances:

• For standard columns that are not already assigned to an existing LOV type, you can change the LOV Type and LOV Bounded properties as necessary.
• For standard columns that are already assigned to an existing LOV type and have the LOV Bounded property set to FALSE, you can change the LOV Bounded property to TRUE. This is only supported in the context of enabling MLOVs.

This task is part of Process of Enabling MLOVs.

To determine if a picklist is bounded from the Picklists list

1. Connect to the server database using Siebel Tools.
2. Select the Flat tab in the Object Explorer.
3. Select the Pick List object type.
4. Query the Type Value property for the list of values type you are interested in.

   If the Bounded property is checked, then that item is a bounded picklist.

To determine if a picklist is bounded from the Columns list

1. Connect to the server database using Siebel Tools.
2. Select the Flat tab in the Object Explorer.
3. Select the Column object type.
4. Query the LOV Type property for the list of values type you are interested in.

   If the LOV Bounded property has a check mark, then the picklist for that target column is bounded.

   NOTE:  The Translate property of the column is only for internal use, and has nothing to do with the configuration of MLOVs.