My Oracle Support Banner

Enh Request:23057068 In OHMPI 2.x, PDQ Does Not Recognize Mother's Maiden Name Query Parameter (Doc ID 2146716.1)

Last updated on FEBRUARY 03, 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


Querying by name, date of birth or gender returns the correct users.
But querying by Mother's Maiden Name does not return anything.

It looks like the query is not considering the Mother's Maiden Name. It should return only the results that match the parameters.

Expect the PDQ works OK when querying by Mother's Name and/or BirthPlace(City) returns the info.


A) Suppose you have 3 users named PEDRO MOREIRA LAURO:

1 - Name:PEDRO MOREIRA LAURO, Mother's Name: MARIA DO CARMO LAURO MOREIRA, BirthPlace/City: (empty)
2 - Name:PEDRO MOREIRA LAURO, Mother's Name: MARIA DO CARMO LAURO MOREIRA, BirthPlace/City: 530010
3 - Name:PEDRO MOREIRA LAURO, Mother's Name: MARIA DO CARMO MOREIRA LAURO, BirthPlace/City: 999999

Notice that there's a difference in Mother's Name and BirthPlace/City between users 2 and 3.

B) The query returns all 3 users instead of 2, as if only the name of the user was used to filter the results.

This problem has a high impact in the business, because the partners that integrate with the customer's database only rely on 5 base attributes to query (Name, Mother's Maiden Name, Gender, Date of Birth and City of Birth). If 2 of these attributes cannot be queried, our partners cannot find the users they are looking for, invalidating the whole integration.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.