My Oracle Support Banner

QuerySpec In CTI Configuration - Error SBL-DAT-00487 (Doc ID 2195189.1)

Last updated on NOVEMBER 12, 2019

Applies to:

Siebel CRM - Version 15.3 [IP2015] and later
Information in this document applies to any platform.
Below is the QuerySpec defined in Event Handler of CTI Configuration:
([Name]='169921' AND [MFP UPN]='966741') OR ([Name]='369921' AND [MFP UPN]='966414')

However the queryspec throws an error SBL-DAT-00487: Current search specification is too complex to be refined.

Upon few research, we found multiple query expression with an 'OR' is not handled in Siebel as per Oracle Doc Id 956294.1. So we tried with the solution provided in same Doc Id and modified QuerySpec as below:
NOT (NOT [Name]='169921' AND [MFP UPN]='966741') AND NOT ([Name]='369921' AND [MFP UPN]='966414'). However the error remained the same as SBL-DAT-00487.

Attached OM and SComm Log FINSObjMgrOui_enu_0010_10485785.log and SComm_USWVAL41_tTf.log (error in 50064 line in OM logs and 2989 line in SComm Log) for reference.

Please let us know if we have to define the queryspec differently in CTI configuration event handler.

Symptoms

 error: error SBL-DAT-00487: Current search specification is too complex to be refined.

Changes

 none

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


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