OHADI Application Toolkit - Identifiers In Patient/individual Service Provider Dimension (Doc ID 2086105.1)

Last updated on DECEMBER 07, 2015

Applies to:

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

Symptoms

 Patient and individual service provider dimension in HCD supports to store four identifiers as below:
IDENTIFICATION_NUMBER
ALT_IDENTIFICATION_NUMBER_1
ALT_IDENTIFICATION_NUMBER_2
ALT_IDENTIFICATION_NUMBER_3
The value types for these attributes are configurable in HCD_ETL_ENTY_SELCTN_PARAM_G based on the ID types.

When loading these dimensions, the following exception occurs: "ORA-01427: single-row subquery returns more than one row"

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