My Oracle Support Banner

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

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.