My Oracle Support Banner

DATAFIX: Emails are not getting moved to the new party after a Party Merge In TCA (Doc ID 816643.1)

Last updated on DECEMBER 03, 2019

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%';




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.