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

Last updated on JULY 13, 2023

Applies to:

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

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