My Oracle Support Banner

"SBL-DAT-00493: Text Constant (0) Needs To Be Enclosed In Single Quotes" Error In PDQ (Doc ID 2126164.1)

Last updated on APRIL 14, 2020

Applies to:

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


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 TEST Campaign List Contact
2. Create search spec as below:
.Search = "[End Date] >= Today () AND [Start Date] <= Today () AND [TEST Campaign List Contact] > 0"


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

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