My Oracle Support Banner

Loading Campaign and Campaign Members via EIM (Doc ID 504597.1)

Last updated on JANUARY 28, 2020

Applies to:

Siebel Enterprise Integration Manager - Version 7.7.2.2 [18356] and later
z*OBSOLETE: Microsoft Windows Server 2003
Version: 7.7.2.2 [18356]

Database: Oracle 9.2.0.6

Application Server OS: Microsoft Windows 2003 Server

Database Server OS: HP-UX 11i



This document was previously published as Siebel SR 38-2558581211.

Symptoms

Could you please advise us how to load a Campaign and its Campaign Members via EIM?

We want to create the Campaign using EIM, rather than create it first in the UI, and the Campaign Members will be existing Contacts within Siebel.

We have worked out the following:

- Use EIM_SRC to create Campaign record in S_SRC
- Use EIM_SRC_DBM to create Wave records in S_CAMP_LD_WAVE and S_DD_CAMP_WAVE
- Use EIM_CAMP_CON to create S_CAMP_CON record linked to Campaign and Waves
- User may then launch the wave using the Web Client

Questions:
- Will this work?
- What is the relationship between the LOAD_NUM column on S_SRC and the LOAD_NUM column on S_CAMP_LD_WAVE?
- What is the point of S_DD_CAMP_WAVE? When you create a Campaign in the UI, a record is automatically created in S_DD_CAMP_WAVE, but the data in it never changes and I can't find where it is shown in the UI.


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
 Message 1

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