Marketing Profile Dashboard not generating WHERE condition (Doc ID 2100366.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Marketing - Version 8.1.1.7 SIA [21238] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.7 SIA [21238] version, Siebel Marketing

Marketing Profile Dashboard Issue.

After upgrading from OBIEE 11.1.1.7.131017 to 11.1.1.7.151020 (OBIA is 7.9.6.4), while viewing the Contact Profile Dashboard from Segment count link in the segment designer, Segment filter is not taken. As a result all Contacts are generated in the Report.

It was working fine before upgrade. The filter for contacts ROW_ID not getting passed from Segment Designer into profile dashboard. The profile dashboard has filter "ROW_ID is prompted". As per query log, the dashboard report runs for all contacts irrespective of the filter.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a segment
2. Save the segment by giving it a name
3. Click on the hyperlink of segment count to Navigate to the profile dashboard.
4. The profile dashboard generates all records and not only the ones counted from Segments

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the desired Contacts from Segments to Dashboards.

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