Activities Created From A Campaign Does Not Fill The Data In The Table S_EVT_MKTG (Doc ID 2192060.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing - Version 8.1.1.11.14 [IP2013] and later
Information in this document applies to any platform.

Symptoms

When a Campaign is launched the activities are created but is not filling column WAVE_ID in the table S_EVT_MKTG.

Customer expects that when Campaign is launched, the activity created during this process has WAVE_ID populated.

STEPS
-----------------------
1) Create an Email Treatment

2) Go to Follow-up Activity view tab and flag "Create Activity"

3) Setup an Email Campaign

4) Load and launch

Log:

MktgCampaignLaunchEvent Info 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Creating activities for campaign recipients with treatment 'ABC Email Treatment', wave Id '1-8VB9' and batch number '1'.
...

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 INSERT/UPDATE statement with ID: Unknown

INSERT INTO SIEBEL.S_EVT_MKTG (
ACTIVE_FLG,
ROW_ID,
MODIFICATION_NUM,
CREATED_BY,
LAST_UPD_BY,
CREATED,
LAST_UPD,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
CONFLICT_ID,
PAR_ROW_ID)
VALUES (:1, :2, :3, :4, :5, :6, :7, current_date, :8, :9, :10)

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 1: N

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 2: 1-8G86

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 3: 0

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 4: 0-1

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 5: 0-1

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 6: 10/01/2016 00:04:24

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 7: 10/01/2016 00:04:24

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 8: Object Manager - Default

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 9: 0

ObjMgrSqlLog Detail 4 0000074d57ec0ecc:0 2016-09-30 17:04:24 Bind variable 10: 1-8G86




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms