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:

Symptoms

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:

Spruyt_cust_1
Spruyt_cust_2

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

Changes

Cause

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