CDA 3.2: W_RXI_DATASOURCE_S Causes Issues When Loading More Than One EDC Trails

(Doc ID 2360778.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle Health Sciences Clinical Development Analytics - Version 3.2.0.0.0 and later
Information in this document applies to any platform.

Goal

In the process of turning on Inform EDC Informatica Mappings and DAC routines for OHSCDA 3.2 application. As additional information, Siebel CTMS is feeding OHSCDA 3.2

There seems to be inconsistency with Datasource_Num_Id in the documentation and mappings on Inform EDC to CDA:


1. Per OHSCDA Installation and Configuration Guide for Informatica Release 3.2 (E74822-01), under step 6 - table 2.1 of (2.1.3 Preparing a DAC Repository for OHSCDA), it says that you need to create separate data source for each trial in W_RXI_DATASOURCE_S. In Oracle's example, the values used are 3 and 101.

2. You followed all the steps, and as an experiment loaded two EDC trials with Datasource_Num_Ids 3 and 101.

2. When ran a test DAC load, the ETL failed on 'SIL_Subject_Status_Fact' due to duplicate records when creating the index U2. Investigating the issue revealed that column STATUS_CODE_WID LOV Lookup was all -1 (not found). Reason being that the lookup has the values with Data_source_num_id = 3, and the actual rows have Data_source_num_id = 101, so the lookup failed in the OOTB mapping.

Which step is missing here that causes these errors?

 

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