My Oracle Support Banner

Performance Issue when searching for a Task Template on the Service Request form (CSXSRISR) (Doc ID 1077802.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Teleservice - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.

Symptoms

On a 12.0.6 instance, using the 'Create Service Request' form (CSXSRISR), when searching on the Task tab for a Task Template it was found that if the full search string was entered the performance of the query was significantly worse than if a wildcard search was used. 

Workaround
First Click in the search field of the LOV.
then enter partial string (like %string%) and perform a search
No performance issues are observed this way

Steps To Reproduce:
The issue can be reproduced with the following steps:
Service (R) >Create Service Request >Task Tab >Use Template (B)
once the template LOV pops, immediately type a partial string to look for the existing Template Group.

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.