My Oracle Support Banner

Refine Opportunity Queries Containing "OR" (Doc ID 2124848.1)

Last updated on APRIL 14, 2020

Applies to:

Siebel Call Center - Version SIA [21238] and later
Information in this document applies to any platform.


On : SIA [21238] version, Client Functionality

When Query Assistant has a "OR" clause, Execute works fine. However, when
"Alt+G" (Refine Query" is used, SBL-DAT-00487 error is displayed and
operation fails.

After using Query Assistant having "OR" clause, Refine Query should work as

The issue can be reproduced at will with the following steps:

1. Log into the Application using Open-UI mode.
2. Go to the All Accounts List view (Accounts > Account List)
3. Lets say there are two records with
Name=Acct-1; Site=Site-1
Name=Acct-2; Site=Site-2
3. Open the Query Assistant view.
4. Query the first two fields as follows:
Name Contains Acct
Site Contains Site
with an "OR" operator.
5 Hit "Go".
6. Results are displayed.
7. Now Click Refine Query or "Alt + G".
8. Notice the error popping up that says:
Current search specification is too complex to be refined.
Please start a new query or refine one that is less complex (SBL-DAT-00487)
9. If Query Assistant is modified to have "AND" operator instead of "OR",
"Alt+G" or "Refine Query" works fine.


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.