OHMPI 3.0 - Real Time Loader Generates New ID's In SBYN_RIDER Table (Doc ID 2141009.1)

Last updated on MAY 23, 2016

Applies to:

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

Symptoms

On : 3.0.0 version, Master Index Data Quality

ACTUAL BEHAVIOR
---------------
OHMPI table called SBYN_RIDER contains generated ID's for every member even if that member does not have riders when using the real time loader.

EXPECTED BEHAVIOR
-----------------------
This table should only be populated when the member has actual rider information.

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

1. Create new project and customize 'create.sql' to add RIDER tables

2. Create loader file with the bellow format:


3. Execute the realtime-loader.bat and notice the results in MBRLOOKUP2.SBYN_RIDER table:

New MBRLOOKUP2ID and RIDERID are generated for every record.

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