![]() |
|
About Picklist Fields, Picklist Value Groups, and DivisionsFor many record types, your company can limit the values that are available in a picklist field to a subset of the values that are defined for the field. To limit the selections in picklist fields, your administrator sets up picklist value groups and links the values in the picklist fields to the picklist value groups. Picklist value groups can control one or more picklist fields on one or more record types. Your administrator can add the Picklist Value Group field to the page layout for a record type. This field allows you to select a picklist value group. Then, in any picklist field that is controlled by the picklist value group that is selected on the record, only the values that are linked to the picklist value group appear in the picklist. For example, assume that your company has three call centers that use Oracle CRM On Demand. Depending on the location of a call center and the products that the call center services, some of the values in a number of picklist fields in service requests are not valid selections for users in the various call centers. To help users to select values that are appropriate for their call center, your administrator sets up three picklist value groups; that is, one picklist value group for each call center. The administrator then links a subset of the values for each of the relevant picklist fields to each of the picklist value groups, and adds the Picklist Value Group field to the page layout for the Service Request record type. When a user in a call center creates a service request, the user can select the appropriate picklist value group for that call center in the Picklist Value Group field on the service request. Then, the choices in the picklist fields on the record are limited to the values that are appropriate for the call center. About Picklist Value Groups and DivisionsIf your company uses the Division record type to organize users into subgroups for business purposes, then your user record might be associated with one or more divisions, one of which is specified as your primary division. Each division can be associated with a picklist value group. In such a setup, when you create a record, the record is automatically associated with your primary division and with the picklist value group that is associated with the division. For a list of the record types in which divisions and picklist value groups can be used, see Record Types That Support Picklist Value Groups and Divisions. NOTE: Your administrator can configure divisions and picklist value groups to meet the business needs of your company. Your administrator can also rename the Division record type and can rename the Division field and the Picklist Value Group field on any record type where the fields are available. Picklist Value Groups and Divisions SetupIf your company uses picklist value groups, then the following setup applies:
If your company also uses the Division record type, then the following setup also applies:
Behavior of the Division and Picklist Value Group Fields When Creating and Editing RecordsIf your company uses picklist value groups and divisions, then the behavior that you see when creating and editing records is as follows:
If the owner of a record changes after a value is saved in the Division field on the record, then the values in the Division field and Picklist Value Group fields are not automatically changed even if the new owner is not associated with the division on the record. What Happens When the Picklist Value Group on a Record ChangesWhen the picklist value group on a record changes either because you select a new division that is associated with a different picklist value group or because you select a new picklist value group, any values that were previously selected in the picklist fields that are controlled by either the old picklist value group or the new picklist value group remain unchanged, even if the value that is selected in such a field is not linked to the new picklist value group. In such cases, you are not prompted to update the picklist value fields when you update other fields on the record. However, the next time that you edit a picklist field on the record, the following happens:
About Picklist Value Groups, Divisions, and Inline EditYou cannot use the inline edit functionality to edit the Picklist Value Group field or the Division field on a record directly in a record Detail page or a record List page. To edit these fields, you must open the Edit page for the record. About Picklist Value Groups and Divisions in Searches and List FiltersThe following considerations apply to searches and list filters:
What Happens if Divisions are Merged or DeletedYour administrator can delete a division or merge two or more divisions into one division. For information about what happens when divisions are merged or deleted, see About Merging Divisions and Deleting Divisions. Related TopicsSee the following topic for additional information: |
Published 1/9/2017 | Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices. |