Siebel Marketing Campaign Load - GetSegmentCount Is Invoked Using SADMIN User As Impersonate

(Doc ID 2349096.1)

Last updated on JANUARY 19, 2018

Applies to:

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

Symptoms

On : 15.5 [IP2015] version, Siebel Marketing

ACTUAL BEHAVIOR
---------------
Siebel Marketing Campaign Load - GetSegmentCount is invoked using SADMIN user as impersonate

While running Marketing Campaign Load flow, the "GetSegmentCount" method from Business Service "Mktg Saw Service" (part of workflow step "Update Load Status (Complete)" from Workflow "Marketing Campaign Load") is getting invoked using SADMIN user as impersonateId instead of the user which triggered the Campaign Load.

In the same Workflow "Marketing Campaign Load", steps 'Prepare Cache' and 'Load Segment Tree Cells/Segments' are using the impersonateId as the user which triggered the Campaign Load.
See below extract from log file :

EXPECTED BEHAVIOR
-----------------------
Method "GetSegmentCount" should be invoked with the user which triggered the Campaign Load.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a campaign
2. Associate an offer, a treatment, a segment / list
3. Perform the allocation

4. Load the campaign being logged with another user than SADMIN and verify the log

Update Load Status (Complete)' step---
Line 502847: MktgGenericEvent Debug 5 000006c85a1c120c:0 2017-11-28 15:10:05 UserName/ImpersonateId: weblogic/SADMIN
Line 503051: XMLConversion EAIXMLCnvDetail 4 000006c85a1c120c:0 2017-11-28 15:10:05 Adding field 'impersonateID' element 'impersonateID' with value 'SADMIN' to XML hierarchy of element 'impersonate'.

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, there is a penalty on performance on OBIEE side, because segment count invoked by SADMIN causes OBIEE to disregard all visibility filters.

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