Oracle CRM On Demand Desktop Administration Guide > How Oracle CRM On Demand Desktop Handles Oracle CRM On Demand Data > How Oracle CRM On Demand Desktop Handles Microsoft Outlook Calendar >

How Oracle CRM On Demand Desktop Uses Natural Keys to Identify a Duplicate Activity

Oracle CRM On Demand Desktop uses natural keys to detect a duplicate between Microsoft Outlook data and Oracle CRM On Demand data. Oracle CRM On Demand Desktop defines the following natural keys for an activity:

• Activity Owner and iCRMId, which matches the ConversationId of an appointment
• Activity Owner and Description, which matches the subject of the appointment and start date

Oracle CRM On Demand Desktop uses these keys to query the Oracle CRM On Demand database. This query determines if a duplicate exists for this activity in the Oracle CRM On Demand database. The following is an example of the natural keys that Oracle CRM On Demand Desktop might define in the connector_configuration.xml file:

<natural_keys>
  <natural_key>
     <field>iCRMId</field>
  </natural_key>
  <natural_key>
     <field>Subject</field>
     <field>StartTime</field><!--Appointment-->
     <field>OwnerId</field>
  </natural_key>
  <natural_key>
     <field>Subject</field>
     <field>DueDate</field><!--Task-->
     <field>OwnerId</field>
  </natural_key>
</natural_keys>

For more information, see Files in the Customization Package.