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 |