My Oracle Support Banner

Customer Center Account search is slow - to_lower() is preventing use of index (Doc ID 1387973.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.Symptoms

Testing of Customer Center has shown significant performance issues with the search on Account Number function.
The SQL used to search on account number uses a to_lower() function which results in a full table scan of account_t table. This takes > 10 minutes with their volume of customer data.
Requesting a ability to do a case insensitive search or provision of a configuration item that allows them to disable the to_lower.
The search functionality works fine in our current 7.0 system.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.