My Oracle Support Banner

Query Assistant - Refine Query With "OR" Operator - SBL-DAT-00487 (Doc ID 2071705.1)

Last updated on FEBRUARY 11, 2018

Applies to:

Siebel Tools - Version 8.1.1.11.10 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Customer is looking for a scripting solution for their Refine Query with the "OR" operator.

Getting the following error when query is refined with OR operator--
(Current search specification is too complex to be refined. SBL-DAT-00487)

Repro STEPS:
1. Log into the 8.1.1.11 Open UI, Patchset 10 or 15.4.
2. Go to the All Accounts List view (Accounts > Account List)
3. Open the Query Assistant view.
4. Query the first two fields with an "OR" operator.
5 Hit "Go".
6. Go to Refine Query or "Alt + G".
7. Notice the error popping up.

Note: If the "AND" operator is used instead of the "OR" operator, the Refine query works fine.

Changes

 

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
References


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