Search By Account Name Fails in Web Call Entry
Last updated on JULY 03, 2017
Applies to:Oracle Utilities Network Management System - Version 220.127.116.11 and later
Oracle Network Management for Utilities - DMS - Version 18.104.22.168 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: "Joseph George H".
On the test system, in Web Call Entry, searching for "joseph" will not return any results.
On the production system, in Web Call Entry, searching for "joseph" 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 "joseph"
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms