My Oracle Support Banner

Performance Issue in Task Based UI (TBUI) Query on Field Made Case Insensitive By CIAI Wizard (Doc ID 1270150.1)

Last updated on JANUARY 31, 2022

Applies to:

Siebel CRM - Version 8.0 SIA [20405] and later
Siebel Applications - Version 8.0 [20405] and later
Information in this document applies to any platform.

Symptoms

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.

Changes

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.

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.