My Oracle Support Banner

Campaign Loads-ARCHIVE (Doc ID 519469.1)

Last updated on JANUARY 06, 2020

Applies to:

Siebel Campaigns - Version 7.5.3.12 [16272] and later
Siebel Marketing - Version 7.5.3.12 [16272] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.5.3.12 [16272]

Database: Microsoft SQL Server 2000 SP3

Application Server OS: Microsoft Windows 2000 Server SP 4

Database Server OS: Microsoft Windows 2000 Server SP 4

Symptoms

I am requesting a little more information of S_DD_USER_KEY table and Integration Object Marketing Contact. I have attached our Marketing Contact integration object for your review.

The issues we are having is Campaign Loads fail when an Account - Contact combination has been previously loaded to a Campaign and the latest load has that same Account with a different Contact assocation.

For example: Account ABC with Contact A has previously been loaded to an older Campaign. A new Campaign is started and segmentation qualifies Account ABC for the Load. However, Contact A has left that company so Contact B is segmented. The Campaign Load fails because it is trying to Insert the same values in S_DD_USER_KEY for SRTFAM_LVL_ID and MSTR_KEY. This would imply that once an Account - Contact assocation has been loaded to a Campaign then no other Contact can be loaded to another Campaign with that same Account.

We have only one Customer Heirarchy named Default Heirarchy and only one Target Level in that Hierarchy named Default Level.

We have two load formats, one that is used to load Account Id as the MSTR_KEY and another that is used to load Contact has the MSTR_KEY. KEY_01 is always the Account Id and KEY_02 is always the Contact Id.

The Integration Key for Contact Key component is Family Level Id (unchanged) and Master Key (Account Id) the EAI Siebel Adapter method is Update or Insert.

How does Siebel support Campaign Loads for updated Account - Contact associations once that Account has been previously loaded with a different Contact?

Changes

 

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
Changes
Cause
Solution
 Message 1
 Message 2

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