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

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

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:

Changes

Customer data is being imported from an alternate CIS system.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms