My Oracle Support Banner

Search By Account Name Fails in Web Call Entry (Doc ID 2281982.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Utilities Network Management System - Version and later
Oracle Network Management for Utilities - DMS - Version and later
Information in this document applies to any platform.


After switching the customer data imports to an alternate CIS system, the customer account name searches no longer work.

In the production system, all CES_CUSTOMERS.ACCOUNT_NAME values are upper-cased.  In the new system, only the first letter of each word is capitalized.
Example: Customer Named "AB".
On the test system, in Web Call Entry, searching for "AB" will not return any results.
On the production system, in Web Call Entry, searching for "AB" will return a number of results.

Account name searches should work regardless of case of text entered

The issue can be reproduced at will with the following steps:
1. Start Web Call Entry
2. Search for "AB"
3. Observe that it returns a number of results

4. Update the current CES_CUSTOMERS table:


Customer data is being imported from an alternate CIS 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.