DATAFIX: Emails are not getting moved to the new party after a Party Merge In TCA

(Doc ID 816643.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Email Center - Version 12.0.4 and later
Information in this document applies to any platform.


The Customer wishes to merge the  two parties into one, in affect shifting all the information stored around the first organisation over to the second.

JTF_IH_INTERACTIONS_VL is used to store information about Interactions for the Customers. This is updated with the merged party_id.

How ever the IEM_ARCH_MSGDTLS and other IEM tables are not updated with the new party_id

Steps To Reproduce
Details on data stored taken from a Support Test case on viscrm01 12.0.6:

Create two new Customers

Resp: TeleSale
Nav:  eBusiness Center

Create two new Organizations:


select party_id, party_number, party_name, email_address from hz_parties
where party_name like 'Spruyt_cust%';


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