"SBL-DAT-00493: Text constant (0) needs to be enclosed in single quotes" Error In PDQ (Doc ID 2126164.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 15.0 [IP2015] version, when attempting to query a view using a PDQ, the following errors occur:

"An error has occurred setting the query specification. Please execute another query or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00313)"

"SBL-DAT-00493: Text constant (0) needs to be enclosed in single quotes"

Reproduction steps:

1. Create a custom calculated field SKB Campaign List Contact
2. Create search spec as below:
.Search = "[End Date] >= Today () AND [Start Date] <= Today () AND [SKB Campaign List Contact] > 0"


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