Querying with an Underscore Returns Other IDs (Doc ID 574133.1)

Last updated on JULY 09, 2014

Applies to:

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

Goal

When a query is run using an underscore in the ID the results include other IDs that are similar but without the underscore.

Example: A query for invoice number 20080227_0003 will return 2008227_0003 and 2008227-0003 although they are different IDs.


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