My Oracle Support Banner

IP17: Find Querying On Fields Which Are Not Set For "Display In Entry" (Doc ID 2366204.1)

Last updated on FEBRUARY 28, 2018

Applies to:

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

Symptoms

On : 17.2 [IP2017] version


ACTUAL BEHAVIOR
---------------
Find Querying On Fields Which Are Not Set For "Display in Entry"

The Find object query takes all the fields which are active in the find object fields in spite of the display in entry flag being set to 'N'. This is causing performance issues.
User search spec:
[Name] LIKE '*Testing*' OR [Account Number] LIKE '*Testing*' OR [CSN] LIKE '*Testing*' OR
[Sales Rep] LIKE '*Testing*' OR [Street Address] LIKE '*Testing*' OR [Main Phone
Number] LIKE '*Testing*' OR [Location] LIKE '*Testing*' OR [City] LIKE '*Testing*' OR
[State] LIKE '*Testing*' OR [Country] LIKE '*Testing*' OR [Postal Code] LIKE '*Testing*'

 

EXPECTED BEHAVIOR
-----------------------
Performance should be nominal when using Find search

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Find Object Account in Call Center Application
Searched on Account Find Object which has the below Active Fields
[Name]
[Account Number]
[CSN]
[Sales Rep]
[Street Address]
[Main Phone Number]
[Location]
[City]
[State]
[Country]
[Postal Code]

In the above fields only [CSN] , [City] , [Country], [Name], [Postal Code] ,
[Sales Rep] , [State] are the fields for which the Display in Entry property
is checked.

[City] , [Name] and [Location] has Display in Results set to true.

2. Login to Application

3. Search with value in global search.

4. The search is executed against all the fields which are Active in the Find object Account and not just the fields which have the Display in Entry property set to True.



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