Performance Issue in Task Based UI (TBUI) Query on Field Made Case Insensitive By CIAI Wizard
Last updated on JULY 22, 2017
Applies to:Siebel CRM - Version 8.0 SIA  and later
Siebel Applications - Version 8.0  and later
Information in this document applies to any platform.
** Checked for relevance on 13-Oct-2015**
Query on a field which has been configured to be case insensitive by the Case Insensitive Accent Insensitive (CIAI) Wizard has poor performance in Task Based UI (TBUI).
Analysis of the SQL for this query in TBUI shows that UPPER function based index is being referenced. This index does not exist on the referenced column.
The column has been configured to be case insensitive by using the CIAI Wizard.
The TBUI task has a query step which performs a query on the field corresponding to this column which has been made case insensitive by CIAI Wizard.
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