OHMPI 3.0 - Blank Street Name Is Causing Zero Weighting For Address (Doc ID 2192309.1)

Last updated on OCTOBER 12, 2016

Applies to:

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

Symptoms

On OHMPI 3.0.0 version,

ACTUAL BEHAVIOR
---------------
When an Address Line 1 contains the word 'House' or 'Flat' no weighting is applied even when they are a perfect match in Phonetic search.

These addresses have no value in the Street Name column in the table SBYN_ADDRESS_SBR.


EXPECTED BEHAVIOR
-----------------------
When an Address Line 1 contains the word 'House' or 'Flat' weighting should be applied.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Add a record containing " House " or " Flat word

2. Check what is the weighted value that should be applied

3. Check the database table SBYN_ADDRESS_SBR if the Street Name is null

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