Oracle CRM On Demandの管理 > アプリケーションカスタマイズ > レコードタイプ別の[アプリケーションカスタマイズ]ページ > Changing Picklist Values
Changing Picklist Values
Some fields give users a drop-down list of predefined values from which they must choose. This list of values is called a picklist. For example, the values in the Area field picklist for service requests might be Product, Installation, Maintenance, and Training.
You can add, edit, and reorder values to the picklists for fields. Picklists must contain at least one value, but the maximum number of values (active or disabled) in a picklist is 1000. The order number for a new picklist entry is automatically populated, but you can change the order number when you edit the picklist.
The system does not allow you to change picklist values used for forecasting and report metrics. However, it does allow you to change other picklist values used as the basis for standard lists that appear in other areas of the application. For those standard lists, the application still includes the records meeting the criteria, regardless of the picklist values you renamed. For more information, see About Fields, Picklists, and Metrics.
After you create a new picklist, an initial value called <No Values> is automatically available in the picklist. This value is used to communicate to users that values do not yet exist in the picklist, in the case where the field is added to a page layout before real values are added to the list. The default <No Values> option disappears from the picklist as soon as a custom value is added to a picklist.
CAUTION: Do not use the default <No Values> value as part of any new picklist or cascading picklist. Using the value in this way can lead to errors within Oracle CRM On Demand. If you want to continue to have a <No Values> option available in a picklist, you must add it as a custom value.
As a best practice, do not rename or reuse the existing picklist values. Instead, disable the old picklist value, create a new picklist value, and perform an import or a mass update (or alternatively, Web Services) to change all record values to new picklist values. If you change a value in a picklist, you must verify that the value is updated and changed for each individual record as this is not implemented automatically by Oracle CRM On Demand.
When changing picklist values, note the following considerations for certain record types and picklist fields:
- Oracle CRM On Demand(標準アプリケーション)では、タスクの優先順位はタスクリストの矢印によって表されます。上向矢印は、[1 - 高]の優先順位を表します。矢印なしは、[2 - 中]の優先順位を表します。下向矢印は、[3 - 低]の優先順位を表します。[活動]レコードタイプの[優先順位]フィールドの表示値をデフォルト値から変更すると(たとえば、デフォルト値の[1-高い]から「最高位」に変更すると)、1-ラベル、2-ラベルまたは3-ラベルというパターン(ラベルはタスク優先順位につけた名前)を使用しない限り、Oracle CRM On Demandでは、タスクリストの[優先順位]フィールドに矢印が表示されません。この場合、Oracle CRM On Demandでは、1-ラベルには上向き矢印が表示され、2-ラベルには矢印が表示されず、3-ラベルには下向き矢印が表示され、他の表示値には矢印が表示されません。たとえば、Oracle CRM On Demandでは、1-My Highestという値には上向き矢印が表示されますが、My Highestという値には矢印が表示されません。Oracle CRM On Demandでは、[優先順位]フィールドのピックリストに追加したカスタム値には矢印が表示されません。
- [活動]レコードタイプの[状態]フィールドのためのピックリスト内で、デフォルトで使用可能な値を追加または編集すると、活動処理のために望ましくない結果が生じる可能性があります。Oracle CRM On Demandでは、具体的には、活動の処理時に[完了]フィールド、[送信]フィールド、[提出済み]フィールドまたは[計画済み]フィールドの値が予期されています。企業でこれらの状態値を非アクティブ化し、それらをカスタム値と置き換えている場合は、Oracle CRM On Demandアプリケーションにおける活動処理は文書化されているとおりには機能しません。そのため、[活動]レコードタイプの[状態]フィールドのピックリストの値の変更はお薦めできません。
- Due to specialized coding, customizing the Oracle CRM On Demand Life Sciences Edition Sample Transaction Type picklist, Account Call Type picklist, and Contact Call Type picklist is not supported.
- サービスリクエストの[状態]フィールドが[クローズ]または[取消済み]に設定されると、サービスリクエストの[終了時間]フィールドはOracle CRM On Demandによって自動的に更新され、状態が変更された日時が表示されるようになります。このため、[サービスリクエスト]レコードタイプの[状態]ピックリストでこれらの値はいずれも非アクティブにしないことを強くお薦めします。ただし、[クローズ]値または[取消済み]値、あるいは両方の値の表示名を変更できます。[クローズ]値の表示名を変更した場合は、サービスリクエストの状態が、元の名前が[クローズ]だったものの値に変更されると、Oracle CRM On Demandによってサービスリクエストの[終了時間]フィールドが更新されます。同様に、[取消済み]値の表示名を変更した場合、サービスリクエストの状態が、元の名前が[取消済み]だったものの値に変更されると、Oracle CRM On Demandによってサービスリクエストの[終了時間]フィールドが更新されます。
In addition, note that commas are used as separators between values when users enter multiple values in a field in a filter for a search or list. If you want to include a comma within a picklist value, then the comma must be followed by a space, so that it will not be treated as a separator in a list of values. If you do not enter a space after a comma when you create or edit a picklist value, then the space is automatically inserted when you save the picklist value. For example, if you enter Value,2 as a picklist value, it is saved as Value, 2.
NOTE: The setting in the Keep Disabled Picklist Value On Update check box on the company profile determines whether a disabled picklist value can remain on a record when the record is updated through the user interface. For more information about how this setting affects the behavior for disabled values in picklist fields, see About the Keep Disabled Picklist Value on Update Setting.
Before you begin. To perform this procedure, your role must include the Customize Application privilege. In addition:
- To add or change values in the Status picklist for the Activity record type, your role must include the Customize Application - Edit Activity ‘Status’ Picklist privilege.
- To add or change values in the Status picklist for the Service Request record type, your role must include the Customize Application - Edit Service Request 'Status' Picklist privilege.
To change picklists
- In the upper right corner of any page, click the Admin global link.
- In the Application Customization section, click the Application Customization link.
- In the Record Type Setup section, click the link for the required record type.
- In the Field Management section, click the required Field Setup link.
- In the record type Fields page, click the Edit Picklist link for the field whose values you want to customize.
- In the Edit Picklist window, perform the following steps as necessary to meet your requirements:
- To change an existing value, enter the new value in the Picklist Values field, or disable the old value and create a new value.
NOTE: If you want this updated name to appear in the picklists for other activated languages, select the Mark for Translation check box. In the other languages, this updated name appears in blue text with brackets until you manually enter the translated versions. This helps you track what terms need to be translated. If you do not select Mark for Translation, the other picklist values are unaffected by the change you made here.
You can also add a description for each picklist value.
- To add a new value, enter the information in the row that appears at the bottom of the list.
To add further new values, click Save & New.
New picklist values you add automatically appear in blue text and brackets in the other activated languages (regardless of the setting of the Mark for Translation check box). If you enter a description for a value, then the description also appears in blue text and brackets.
- To delete a value, select the Disabled check box. To hide or show disabled values, click Hide Disabled and Show Disabled respectively.
CAUTION: When you disable values, you also hide the translated versions in other languages.
- To arrange the order in which the picklist values appear, change the numbers in the Order column.
TIP: Consider entering numbers with gaps between them, such as 10, 20, 30, and so on. This allows you to add new values in the middle of the picklist more easily, without reordering the entire list.
- To arrange the picklist values in alphabetical order for the current language only, click the Save & Order Alphabetically button.
- To arrange the picklist values in alphabetical order for all languages, click the Save & Order Alphabetically For All Languages button.
- In the Edit Picklist window, click Save & Close.
- To manually enter the translated equivalent of a new picklist value or the description of a value:
- On the Fields page, select the language from the Translation Language drop-down list.
- Click the appropriate Edit Picklist link.
- Enter the translated equivalent and click Save.
NOTE: To help you identify the picklist value when you are editing, the application displays the internal ID and the language-specific default value. If you edit the wrong picklist value, the picklist becomes out of sync across languages. When using dynamic layouts, you cannot use picklist values that are identical to internal picklist IDs as this can result in unpredictable behavior.
|