Siebel Server Sync Guide > Customizing Siebel Server Sync for Microsoft Exchange Server >

Creating Custom Delete Triggers

The following procedure describes how to create a custom delete trigger. For more information about custom delete triggers, see About Creating Custom Delete Triggers.

CAUTION:  If you want to create custom delete triggers, you must contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services. If you do not, you might invalidate your support agreement.

To create a custom delete trigger

  1. Determine which Siebel domain is associated with the record to be deleted, and use the following table to determine the corresponding SEBL_DOMAIN_IDEN value to use in a later step.
    Siebel Domain Name

    Siebel Business Contact

    PIMSI Intermediate Business Contact

    Siebel Calendar

    PIMSI Intermediate Calendar

    Siebel Employee

    PIMSI Intermediate Employee

    Siebel Personal Contact

    PIMSI Intermediate PersonalContact

    NOTE:  There is no space between Personal and Contact in this value.

    Siebel Task

    PIMSI Intermediate Task

  2. Locate the script that creates the database triggers that are supplied along with SSSE for your database environment.

    The following table lists the script names for each database environment. These scripts are typically located in the siebsrvr/BIN directory on your Siebel Server.

    Script Name



    DB2 390


    Microsoft SQL Server




  3. In the appropriate script file for your database environment, review existing delete triggers to see examples of the specific language required for each domain and operation.

    The following table lists some existing trigger names and the contexts in which they direct SSSE to delete specified PIM records.

    Delete Trigger Name
    Trigger Requests Deletion of PIM Record if:


    A user changes the owner of an activity record (calendar or task)


    A user removes a business contact, employee, or personal contact record from his or her Sync List


    A user converts a personal contact record to a business contact record


    A user changes the owner of a personal contact record


    A user converts a calendar record to a task record, or a task record to a calendar record

  4. Write the new delete trigger you require, using an appropriate existing trigger as a model.

    For an example of one existing trigger, see Sample Delete Trigger.

  5. Use a tool such as SQL Query Analyzer to apply the new trigger to the database.
  6. Test the trigger by completing the following substeps:
    1. Create a Siebel record of the type that your new trigger is designed to monitor, such as a business contact record.
    2. If necessary, add the record to your Sync List, and verify that SSSE creates a corresponding PIM record.
    3. Perform the operation that your new trigger is designed to detect, such as deleting or updating the business contact record, or removing it from your Sync List.
    4. Verify that the expected result occurs—one or more delete trigger records are added to the S_SD_SYNC_INFO table, and SSSE deletes or updates the corresponding PIM record, as specified in your trigger.
Siebel Server Sync Guide Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.