Print      Open PDF Version of Online Help

Previous Topic

Next Topic

About the Information in Modified Fields on Records

Oracle CRM On Demand uses the following system fields to store information about the most recent change to a record:

  • Modified External
  • Modified: Date
  • Modified By
  • Modified: Date External

In certain cases, Oracle CRM On Demand writes information to one or more of these fields to reflect a change to the record that is not caused by an explicit user action. For this reason, it is recommended that you do not rely on the information in these fields to track the changes that users make to records. Instead, use the audit trail feature to track the changes that users make to specific fields on records. For information about customizing the audit trail for record types, see Customizing the Audit Trail.

The following is an example of a system change to the Modified By field on a record. A user deletes an account that is linked to a contact record as the primary account for the contact. When the deleted account record is purged from the database, the link between the deleted account and the contact is removed from the database. After the link is removed from the database, the next time that the contact record is opened by any user, Oracle CRM On Demand selects another linked account as the primary account on the contact and writes the ID of the account to the primary account field. Or, if there are no accounts linked to the contact, then Oracle CRM On Demand updates the record to reflect that. Oracle CRM On Demand then updates the Modified By field with the name of the user who opened the contact record.

Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.