Last updated on JULY 04, 2016
Applies to:Oracle Fusion Sales - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms