Error while Filtering the Records by Giving Date Values in Marketing Calendar in Siebel 8.1.1.14.3 (Doc ID 2036534.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.14.3 [IP2014] version, Client Functionality

Error while filtering the records by giving date values in marketing calendar in siebel 8.1.1.14.3

ERROR
-----------------------
[1] Invalid search specification '[End Date] = '08/28/2015 AND [Start Date] = '07/22/2015' for named search 'Filter Attributes'.

Please continue or ask your systems administrator to check your application configuration if the problem persists. (SBL-DAT-00458)

[2] Invalid search specification '[End Date] = '08/28/2015 AND [Start Date] = '07/22/2015'.

Please continue or ask your systems administrator to check your application configuration if the problem persists. (SBL-DAT-00501)

[3] Expression does not match any Siebel query language grammar rules. Unexpected token '08/28/2015 AND [Start Date] = 'found at or near location 45.(SBL-DAT-60236)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1.Open Marketing Application
2.Navigate to Marketing Calendar Screen-Tactics view
3.Click on Filter,provide start date and end date and Filter
4.Error:Expression does not match any Siebel query language grammar rules. Unexpected token '07/17/2015' found at or near location 45.(SBL-DAT-60236) is observed

BUSINESS IMPACT
-----------------------
The issue has the following business impact:


Due to this issue, users cannot search using combination of start date and end date.

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