Unable To Find Correct Data When Searching By Description

(Doc ID 780934.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 5.5 to 5.5.05.03
Information in this document applies to any platform.

Goal

When searching a shipment or an invoice and try to do a search by accessorial description, typing in 'LIFT', for example, in the description returns no results, even though there is an accessorial with that description associated to shipments. The accessorial descriptions stored in the dbs includes lower case letters.  When you enter the description to search by, it converts it to the upper case and does not find any matches.

Solution

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