Load_Research_Patient_D has an invalid mapping the column PATIENT_IDENTIFIER (Doc ID 2290550.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Healthcare Translational Research - Version 3.1 to 3.1.0.4 [Release 3.1]
Information in this document applies to any platform.

Symptoms

In the Package Load_Research_Patient_D, for the interface INT_TMPAPPS_W_EHA_RESEARCH_PATIENT_D the mapping for the column PATIENT_IDENTIFIER has a typo:
CASE
WHEN '#PATIENT_IDENTIFIER_FLG 'IS NULL THEN HDM_PT.PT_NBR -- typo before IS NULL, the single quotation mark needs to be before the space and not after.
WHEN '#PATIENT_IDENTIFIER_FLG'='N' THEN TO_CHAR(HDM_PT.PT_ID)
END

This results in not loading value in the target table.



EXPECTED BEHAVIOR
-----------------------

The mapping for the column PATIENT_IDENTIFIER should be:
CASE
WHEN '#PATIENT_IDENTIFIER_FLG' IS NULL THEN HDM_PT.PT_NBR
WHEN '#PATIENT_IDENTIFIER_FLG'='N' THEN TO_CHAR(HDM_PT.PT_ID)
END


STEPS
-----------------------

The issue can be reproduced at will with the following steps:
1. From ODI connect to TRC repository;
2. Navigate to "Oracle Healthcare Analytics" > "Mappings" > "Dimensions" > "Load_Research_Patient_Dimension" > "Packages"
3. Open the "Load_Research_Patient_D" package, go to "Diagram" tab.
4. Open the interface INT_TMPAPPS_W_EHA_RESEARCH_PATIENT_D.
5. Go to Mapping tab.
6. In Target Datastore - W_EHA_RESEARCH_PATIENT_D, the mapping for the column PATIENT_IDENTIFIER has a typo:
CASE
WHEN '#PATIENT_IDENTIFIER_FLG 'IS NULL THEN HDM_PT.PT_NBR -- typo before IS NULL, the single quotation mark needs to be before the space and not after.
WHEN '#PATIENT_IDENTIFIER_FLG'='N' THEN TO_CHAR(HDM_PT.PT_ID)
END




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