OHADI: Error "The Attributes (PRDMSR_INT_ID,PRDMSR_DAT_SRC_NUM_ID) and (SUBST_CD,SUBST_CDG_SYS,SUBST_CDG_SYS_VER) are Mutually Exclusive and Hence Only One of Them Must be Present at Any Point of Time." (Doc ID 2194049.1)

Last updated on OCTOBER 26, 2016

Applies to:

Oracle Healthcare Analytics Data Integration - Version 3.0.0 to 3.1 [Release 3.0 to 3.1]
Information in this document applies to any platform.

Symptoms

OHADI 3.0, you encounter the following error message when you run a data Load to HDM_RX_LN from HDI_RX_LN:

The attributes (PRDMSR_INT_ID,PRDMSR_DAT_SRC_NUM_ID) and (SUBST_CD,SUBST_CDG_SYS,SUBST_CDG_SYS_VER) are mutually exclusive and hence only one of them must be present at any point of time.


o Data Load to HDM_RX_LN from HDI_RX_LN table fails with the error for every record

o For this case, there was no functional requirement for populating (PRDMSR_INT_ID, PRDMSR_DAT_SRC_NUM_ID) and (SUBST_CD, SUBST_CDG_SYS, SUBST_CDG_SYS_VER)

o No changes to HDI_ETL_RL_G table

o Data is not coming in from new sources

o The extraction logic has not changed



EXPECTED BEHAVIOR
-----------------------
That the data Load to HDM_RX_LN from HDI_RX_LN completes with no error messages.


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