My Oracle Support Banner

Query ID Not Available In RXI_INFORM (CDA InForm Consolidation Schema) (Doc ID 2439204.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

CDA 3.X, InForm 6.1 versions
CDA InForm Consolidation Schema issue.

ACTUAL BEHAVIOR
---------------
Query Id <###> was generated in InForm and passed to CODA but it is missing in the RXI Inform schema. Other data is received. The issue is with a specific query. No errors are displayed, just missing query id.
The data is pushed into consolidated schema(RXI_INFORM) through the scripts that are deployed in the respective CDA schema. 


Have hence checked the data only until RXI_INFORM schema where the query is missing. Please make a note that the query id is same in InForm reporting as well as INFORM transactional.

EXPECTED BEHAVIOR
-----------------------
The expectation is the data is picked from InForm reporting and pushed into RXI_INFORM schema (a.k.a CDA InForm Consolidation Schema) through the scripts deployed in CDA schema.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 2.2.4.2 Destination Consolidation Database Configuration


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.