My Oracle Support Banner

When Using Wildcard, The PDQ Query Is Case-sensitive ( PDQSupplier Service Query Request ) (Doc ID 2030739.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Oracle Healthcare Master Person Index - Version 2.0.9 and later
Information in this document applies to any platform.


OHMPI 2.0.9

When sending a PDQSupplier Service query request AND using wildcards, the PDQ query by name is case-sensitive (ie, http://host:port/PDQSupplier_Soap12/PDQSupplier_Service ).

For Alphanumeric search type, the fields are case-sensitive. Example:

- if search for DAVID GREGORYX, have 1 result
- if search for DAV% GREGORYX, have 1 result
- if search for David GREGORYX or Dav% GREGORYX or any other lowercase combination, no result found

 Steps To Reproduce

1. Identify a valid PATIENT name - looking into IHEOHMPI30.SBYN_PATIENT table

2. For example, we use DAVID GREGORYX (00000000000000000028)

3. Send a PD query to search for 'DAVID' in this system:


6. Use wildcard inside the query (David %) - same results code="NF" (NOT FOUND)

7. Use any combination of lowercase and wildcard: - same results code="NF" (NOT FOUND)


To view full details, sign in with your My Oracle Support account.

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

In this Document

 Steps To Reproduce

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.