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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

OHMPI 2.0.9


ACTUAL BEHAVIOR
---------------

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.


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

EXAMPLE TO REPRODUCE THE ISSUE
-----------------------------------------

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.

BUSINESS IMPACT
-----------------------
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.

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