My Oracle Support Banner

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

Last updated on JANUARY 31, 2019

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.

Changes

 

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
Changes
Cause
Solution
References


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