| Print Open PDF Version of Online Help

#### Examples of Modification Tracking Event Records This topic provides several examples of modification tracking event records created by Oracle CRM On Demand for certain user actions. After the modification tracking feature is enabled, event records are listed in the Modification Tracking List Page, as shown in the following examples. Depending on the type of user action and the relationship of the record types recorded, several records can be written as a result of one event. For example, if there is a one-to-many parent-child relationship or a many-to-many object-to-object relationship, several records can be written. ### Example 1: Modification Tracking Record for Creating a New Account Record In this example, a user creates a new account record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | None | None | WriteRecordNew | None | None | 0 | 03/26/2014 09:28 AM
### Example 2: Modification Tracking Record for Updating an Existing Account Record In this example, a user updates an existing account record by modifying a field in the account record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | None | None | WriteRecordUpdated | None | None | 1 | 03/26/2014 09:52 AM
### Example 3: Modification Tracking Record for Deleting an Existing Account Record In this example, a user deletes an existing account record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | None | None | PreDeleteRecord | None | None | 2 | 03/26/2014 09:58 AM
Account | 1QA2- OD54E | None | None | DeleteRecord | None | None | 3 | 03/26/2014 10:00 AM
### Example 4: Modification Tracking Record for Restoring an Account Record Marked for Deletion In this example, a user restores a record marked for deletion before it is purged from Oracle CRM On Demand. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | None | None | RestoreRecord | None | None | 3 | 03/26/2014 10:03 AM
### Example 5: Modification Tracking Record for Associating an Account Record with a Contact Record In this example, in a contact record, a user adds an existing account record to the contact record; that is, the user associates the account record with the contact record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Contact | 1QA2- OD635 | Account | 1QA2- OD54E | Associate | None | None | 0 | 03/26/2014 10:16 AM
Contact | 1QA2- OD635 | None | None | WriteRecordUpdated | None | None | 1 | 03/26/2014 10:16 AM
Contact | 1QA2- OD635 | Account Contact | 1QA2- OD639 | WriteRecordUpdated | None | None | 1 | 03/26/2014 10:16 AM
Account | 1QA2- OD54E | Contact | 1QA2- OD635 | Associate | None | None | 0 | 03/26/2014 10:16 AM
Account | 1QA2- OD54E | Contact | 1QA2- OD635 | WriteRecordUpdated | None | None | 4 | 03/26/2014 10:16 AM
Account | 1QA2- OD54E | None | None | WriteRecordUpdated | None | None | 4 | 03/26/2014 10:16 AM
Contact | 1QA2- OD635 | Account | 1QA2- OD54E | WriteRecordUpdated | None | None | 4 | 03/26/2014 10:16 AM
### Example 6: Modification Tracking Record for Disassociating an Account Record From a Contact Record In this example, a user removes a related account record from a contact; that is, the user disassociates the account record from the contact record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | None | None | WriteRecordUpdated | None | None | 5 | 03/26/2014 10:35 AM
Contact | 1QA2- OD635 | None | None | WriteRecordUpdated | None | None | 2 | 03/26/2014 10:35 AM
Contact | 1QA2- OD635 | Account | 1QA2- OD54E | Dissociate | None | None | 1 | 03/26/2014 10:35 AM
Account | 1QA2- OD54E | Contact | 1QA2- OD635 | Dissociate | None | None | 1 | 03/26/2014 10:35 AM
### Example 7: Modification Tracking Record for Adding a Child Record to a Parent Account Record In this example, in an account record, a user creates a new address record as a related item; that is, the user adds the account address as a child record of the parent account record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | Address | 1QA2- OD6PM | WriteRecordNew | None | None | 0 | 03/26/2014 11:44 AM
Account | 1QA2- OD54E | None | None | WriteRecordUpdated | None | None | 6 | 03/26/2014 11:44 AM
### Example 8: Modification Tracking Record for Updating an Existing Child Record In this example, in an account record, a user updates an existing address record; that is, the user updates the account address as a child record of the parent account record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | Address | 1QA2- OD6PM | WriteRecordUpdated | None | None | 1 | 03/26/2014 11:51 AM
### Example 9: Modification Tracking Record for Updating an Existing Child Record In this example, in an account record, a user deletes the existing address record; that is, the user deletes the account address as a child record of the parent account record. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Account | 1QA2- OD54E | None | None | WriteRecordUpdated | None | None | 8 | 03/26/2014 12:00 PM
Account | 1QA2- OD54E | Address | 1QA2- OD6PN | None | None | None | 1 | 03/26/2014 12:00 PM
### Example 10: Modification Tracking Record for Updating a Picklist Value In this example, in an account, a user updates a picklist, that is, the user customises an existing Priority picklist field on an Account record by adding a value called Indeterminate. Oracle CRM On Demand generates an event record similar to the record in the following table.
Object Name | Object Id | Child Object Name | Child Object Id | Event Name | Record Type | Field Name | Modification Number | Modified: Date
--- | --- | --- | --- | --- | --- | --- | --- | ---
Picklist | 1QA2- OD54E | None | None | WriteRecordUpdated | Account | Priority | 8 | 03/26/2014 1:00 PM
### ### Related Topics For related information on the modification tracking feature, see the following topics: Modification Tracking Enabling the Modification Tracking Feature Record Types that are Tracked About Modification Tracking Events Viewing the Modification Tracking List Page Modification Tracking Information for Changes to Lists of Values in Picklists Creating Modification Records Manually

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.