Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Application Customization > Record Type Application Customization Page > About the Keep Disabled Picklist Value on Update Setting

About the Keep Disabled Picklist Value on Update Setting

The setting in the Keep Disabled Picklist Value On Update check box on the company profile determines the following:

• Whether a disabled picklist value can remain in a field on a record when a user updates the field inline or edits the record through the user interface.
• Whether the Import Assistant can update a multi-select picklist field with a list of values that includes one or more disabled values that are already selected in the field.

How the Setting Affects Updates in the User Interface

If the Keep Disabled Picklist Value On Update check box on the company profile is not selected, then when a user edits a record that contains a disabled value in a picklist field through the user interface, the behavior is as follows:

• If the user edits the picklist field inline, then the disabled value is no longer available for selection in the field.
• If the user opens the record in a record Edit page that displays the picklist field, then the disabled value is removed from the field and is no longer available for selection. If the field that contained the disabled value is the parent in a cascading picklist, then the related picklist field is also cleared.

In both of these cases, if the user cancels the operation without saving any changes, then the disabled value remains in the field, and if the field is the parent in a cascading picklist, then the existing value in the related picklist field is unchanged.

If the Keep Disabled Picklist Value On Update check box on the company profile is selected, then when a user edits a record that contains a disabled value in a picklist field through the user interface, the behavior is as follows:

• If the user edits the picklist field inline, then the disabled value that was previously selected is still available for selection in the field, as well as any active values. The disabled value appears last in the list of values that can be selected for the field. However, if the user removes the disabled value from the picklist field, then after the user saves the update, the disabled value is no longer available for selection in the field.
• If the user opens the record in a record Edit page that displays the picklist field, then the disabled value is not removed from the picklist field, even if the user edits other fields in the record and save the updates. If the user edits the field that contains the disabled value, then the disabled value is still available for selection, as well as any active values. The disabled value appears last in the list of values that can be selected for the field. If the user removes the disabled value from the field, then after the user saves the update, the disabled value is no longer available for selection in the field.

  If the field that contains the disabled value is the parent in a cascading picklist, then in the related picklist, only the value that was previously selected is available. If the user selects a new value in the parent picklist, then the values that are associated with the new parent value become available in the related picklist.

How the Setting Affects Updates from Other Channels

For updates to records from other channels, the setting in the Keep Disabled Picklist Value On Update check box on the company profile is considered only in the case where the Import Assistant attempts to update a multi-select picklist field with import data that contains one or more disabled values. If the check box is not selected, then the multi-select picklist field is not updated. However, if the Keep Disabled Picklist Value On Update check box is selected, then the following happens:

• If all of the disabled values in the import data are already selected in the record, then the field is updated and the disabled values remain in the list of values.
• If the import data contains at least one disabled value that is not already selected in the field, then the field is not updated.

Note that the setting in the Keep Disabled Picklist Value On Update check box on the company profile is not considered in the following cases:

• When a record is updated through Web services, or a JavaScript API method, or a REST API request, and a disabled value is included in the import data for a multi-select picklist field. In this case, the disabled value is always imported.
• When a record that contains a disabled value in a single-value picklist field is updated through any channel other than the user interface. In this case, the disabled value is never removed from the field on the record unless a new, active value, or a null value is specified for the field in the import data.

By default, the Keep Disabled Picklist Value On Update check box on the company profile is not selected, but your administrator can change this setting.