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 AUGUST 24, 2018

Applies to:

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

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

Cause

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
Symptoms
Cause
Solution

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