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

Last updated on APRIL 12, 2016

Applies to:

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

Symptoms

On : 8.1.1.7 SIA [21238] version, Client Functionality

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
After using Query Assistant having "OR" clause, Refine Query should work as
normal.

STEPS
-----------------------
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.


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