Quotes Are Not Coming Up When Adding Marketing System Data In OBIEE (Doc ID 2147439.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On :  8.2.2.14.11 [IP2014] version, Siebel Marketing

ACTUAL BEHAVIOR  
---------------
Quotes are not added with the Marketing System Data in OBIEE  

In OBIEE 11g, we have marketingwebexpression.xml file which contains all the system data used to pass on to OBIEE from Siebel. For instance, the following is for CampaignId:


kmsgMktgWebExprCampaignID


However, when you create a filter and try to add one of the system fields, in 11g it gets added as:

@{CampaignID}{}

where as in 10g it was previously added as:

'@{CampaignID}{}'

It seems the 'usequotes' parameter has no effect in OBIEE 11g whether set to true or false, but works in OBIEE 10g.

However, once you do add the parameter you can manually add the single quotes.

EXPECTED BEHAVIOR
-----------------------
The parameter 'usequotes' should work as previous versions.

STEPS
-----------------------
-Create a new list
-Add a filter
-For the value select advanced options
-Out of different options choose 'System Data'

BUSINESS IMPACT
-----------------------
Users can manually add the single quotes, but admins may want some field to have quotes and some to not, so this would be hard for users to track manually.

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