Deactivating a Value in a List of Values

Deleting LOVs is not recommended since it may lead to referential integrity problems in the database and unexpected application behavior. Rather than deleting LOVs or values in an LOV, deactivate them as described in the following procedure.

Only the active values in a list appear to users, inactive values do not appear to users. Inactive values are not deleted.

Caution: Be careful when deactivating LOVs because the application might depend on the list of values. Deactivating some LOVs can adversely impact standard Siebel functionality.

For example, if you deactivate the value Commercial in the Account_Type list of values, but account data with an Account Type of Commercial exists, then you might introduce inconsistencies in your data. If you want to deactivate a value, then clean up the account records first in the Siebel database.

To deactivate a value in a list of values

1. Navigate to the Administration - Data screen, then the List of Values view.

2. Query for the record that you want to deactivate.

3. Select the record that you want to deactivate.

4. In the Active field, click the check mark to clear the field.

5. Click Clear Cache.

   You can navigate to the list of values to see that the value no longer appears.