My Oracle Support Banner

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.


On OHMPI 3.0.0 version,

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.

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

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


To view full details, 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 a vibrant support community of peers and Oracle experts.