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

Last updated on MARCH 02, 2017

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.

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