"SBL-DAT-00493: Text constant (0) needs to be enclosed in single quotes" Error In PDQ
Last updated on MARCH 02, 2017
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"
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms