My Oracle Support Banner

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

Last updated on NOVEMBER 02, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version to [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.


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

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