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