Search Locations By Contact's Email Returns no Results as it Converts Email to Upper Case (Doc ID 1382364.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.1.0 to 6.3 - Release: 6.1 to 6.3
Information in this document applies to any platform.

Symptoms


When trying to query for a location by the email address of a contact, the email ID gets converted to capitals and no locations are retrieved, since email addresses on contacts are usually stored in lower case. I.e. they remain in lower case when entered that way on the contact info.

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