Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Modification Tracking Information for Changes to Lists of Values in Picklists

This topic describes how you can use the modification tracking feature to track changes to the list of values in picklists. To track changes to picklists, you enable Picklist for the modification tracking feature in addition to the record type that contains the picklist. Picklist is available as an object name in the Modification Tracking List page. Oracle CRM On Demand logs the name of a record type on the Modification Tracking List page for a create, read, update, or delete operation on the picklist for the record type, if the modification tracking feature is enabled for the Picklist object. The following table describes the columns in the Modification Tracking List page when you enable the modification tracking feature for the Picklist object.

Column Heading

Description

Object Name

Picklist.

Object Id

The row identifier for the object that Oracle CRM On Demand assigns, for example, 1QA2-NX0XH. This identifier is unique to the list of values associated with a picklist.

Certain fields use the same list of values across multiple objects. If a user edits any value in the list of values, then Oracle CRM On Demand logs modification tracking entries for all the fields. In this case, the object identifier is the same for all such modification tracking entries.

Record Type

The modification tracking name of the record type whose picklist is edited. It is the name of the record type as it appears in the Modification Tracking Page when the record type is tracked.

Field Name

The Web services version 2.0 tag of the picklist field that is edited.

Whenever you edit a picklist field, an entry appears in the Modification Tracking List page, but only if you have enabled the record type whose picklist field you are editing for the modification tracking feature. A single edit to a picklist field on a particular record type can cause multiple entries to be recorded in the Modification Tracking List page because Oracle CRM On Demand maps the picklist fields to the list of value types that are shared among multiple picklist fields across record types. The number of entries is equal to the number of public fields that are mapped to the list of value types of the picklist fields that you edit.

For example, assume that you have a picklist called Picklist Role, with a list of values type set to PARTY_REL_TYPE, and this picklist is also used by the following record types: Account Partner, Account Competitor, Opportunity Competitor, Opportunity Partner. Assume that the picklist is also used by two fields in these record types: Role and Reverse Role. If you update the list of values for any picklist field in this example, then Oracle CRM On Demand creates separate modification tracking entries for all the picklist fields in the example.

Restrictions for Modification Tracking for a List of Values in Picklists

Oracle CRM On Demand does not create modification tracking events for a list of values in picklists with the following conditions:

  • The record type associated with the picklist is not set up for your company.
  • The picklist updates belong to record types that are not enabled for the modification tracking feature.
  • The updated picklist field is not accessible through Web services.

Related Topics

For related information on the modification tracking feature, see the following topics:


Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.