How To Load W_HCD_PATIENT_D/W_HCD_IND_SVC_PROV_D Table without Splitting the Patient Record into Multiple Records (Doc ID 2034206.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Analytics Data Integration - Version 3.0 and later
Information in this document applies to any platform.

Goal

On Oracle Healthcare Analytics Data Integration (OHADI) 3.0, there is an issue while loading W_HCD_PATIENT_D table as it accepts only one address location for an individual party.
In the customer's data, there are multiple address locations of the same type against an individual party.
Due to this issue, Patient record is splitting into multiple records.

The same issue exists in Individual Service Provider Dimension view which is used to load W_HCD_IND_SVC_PROV_D table.

How does one may load W_HCD_PATIENT_D/W_HCD_IND_SVC_PROV_D table without splitting the Patient record into multiple records?

Solution

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