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

Deleting Compared to Deactivating MLOV Records

As you administer MLOVs, you may find that there are records that you no longer need and would like to make inactive. If you delete a MLOV record, then records in other tables that have already been entered using that list of values record will no longer display correctly. The display value in the list of values entries is used to display the language-specific text.

Instead of deleting a record, inactivate it. Inactive values that have already been used and are referenced in other tables in the database will still display correctly. Inactive records are not included in any picklists, however, and are ignored by EIM when it performs validation against LOVs.

The Active list column in the List of Values Administration view is checked by default. To deactivate a record, remove the check mark.

If you try to delete a record, you will get a message asking you if you really want to delete the record, or just deactivate it. If you choose Inactivate from the dialog box, the check mark in the Active list column is removed.

If you do delete an LOV record, any language-independent codes in the target columns referring to the deleted record will then display the language-independent code. Searching and sorting will not function correctly on these values.