Oracle Migration Tool On Demand Guide > Migrating Picklist Value Groups >

Picklist Value Groups


You can use a picklist value group to limit values that users can select in a picklist. A picklist value can be mapped to one or more picklist value groups. However, if there are no values mapped to a picklist value group, then the picklist displays all values. For more information about picklist value groups see, Oracle CRM On Demand Online Help.

For example, if an Account record has a defined picklist value group, then only the picklist values mapped to the defined picklist value group are displayed in the respective picklist fields. The following is a typical picklist value group structure:

<PVG1>
       <Account/Account Type>
               <Account Type Value1>
               <Account Type Value2>
       <Service Request/Status>
               <SR status value1>
               <SR status value14>
<PVG2>
       <Account/Account Type>
               <Account Type Value2>
               <Account Type Value3>
       <Account/Account Status>
               <Account Status Value1>
               <Account Status Value3>

Table 16 describes the Oracle Migration Tool On Demand client commands used with picklist value groups. For more information about running these commands, see Migrating Picklist Value Groups.

Table 16. Oracle Migration Tool On Demand Commands for Picklist Value Groups
Command
Description

Read PickValueGroup PickValueGroupName

This command exports the picklist value group details for the specified picklist value group.

ReadAll PickValueGroup

This command exports all picklist value groups in the Oracle CRM On Demand tenant.

Upsert PickValueGroup PickValueGroupXML

This command updates or inserts a picklist value group.

NOTE:  Nonadministrative Oracle CRM On Demand users can run the Read and ReadAll command.

Oracle Migration Tool On Demand Guide, Release 37 Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.