Trigger A Logic While Merging Two Contacts

(Doc ID 2154097.1)

Last updated on JULY 04, 2016

Applies to:

Oracle Fusion Sales - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Customer has created a global function which is being used to delete an existing Account-Contact relationship while creating a new Account-Contact relationship of the same type i.e. 'CONTACTORG'.
Customer has created two triggers 'AfterInsert' and 'AfterUpdate' on Relationship object to invoke this function. Both triggers and Global Function are working fine.
The actual problem is, when merging two contact records the triggers on Relationship object are not getting invoked hence the final contact record getting created with two Account-Contact relationship of same type 'CONTACTORG'.
Customer is asking for help to find out the correct triggering point. As they have tried different types of trigger like 'AfterUpdate', 'AfterCommit' etc. on both Contact and Relationship object.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms