Campaign Load In Progress State Due To Calendar REI BusComp not having SRC_ID (Doc ID 2215678.1)

Last updated on JULY 07, 2020

Applies to:

Symptoms

On : 16.0 [IP2016] version, Siebel Marketing

When trying to run a Campaign Load in IP16, Campaign Load remains In Progress state due to Calendar REI BusComp.

Then, the following error occurs:


ERROR
-----------------------

ObjMgrSqlCursorLog Trace 5 0000000257b7362c:0 2016-08-19 09:09:39 SQL Cursor with ID 1AF292B8 Buscomp: Calendar REI, Forward Only: 0, Fetch Rows: 10000, Fetch All Time: 2.038 seconds.
ObjMgrSqlCursorLog Close 5 0000000257b7362c:0 2016-08-19 09:09:39 End: Close Sql Cursor at 1af292b8
ObjMgrBusCompLog Error 1 0000000257b7362c:0 2016-08-19 09:09:39 There were more rows than could be returned. Please refine your query to bring back fewer rows".


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure a Campaign in IP16

2. Schedule the Campaign

3. Load it

In the log you will see that the query generated does not have SRC_ID in the WHERE clause causing all records within a certain date to be selected from S_EVT_ACT and not only the ones related to the executed Campaign.

...

WHERE
T5.PARENT_ACTIVITY_ID = T2.PAR_REPTEVT_MST_ID (+) AND
T5.PAR_REPTEVT_MST_ID = T3.ROW_ID (+) AND
T3.OPTY_ID = T4.ROW_ID (+) AND
T3.OPTY_ID = T1.ROW_ID (+) AND
((T3.TEMPLATE_FLG != 'Y' AND T3.TEMPLATE_FLG != 'P' OR T3.TEMPLATE_FLG IS NULL) AND (T3.OPTY_ID IS NULL OR T4.SECURE_FLG = 'N' OR T1.OPTY_ID IS NOT NULL)) AND
(T5.REI_TS < TO_DATE(:2,'MM/DD/YYYY HH24:MI:SS') AND T5.REI_END_TS >= TO_DATE(:3,'MM/DD/YYYY HH24:MI:SS') AND T5.PAR_REPTEVT_MST_ID IN (
SELECT SQ1_T1.ACTIVITY_ID
FROM SLICCCO.S_ACT_EMP SQ1_T1
WHERE (SQ1_T1.EMP_ID = :4)))
ORDER BY
T3.TODO_PLAN_START_DT

Changes

 Please do note that this does NOT occur in IP16.1 Patchset 1. 

Cause

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