Draft CIOMS-I Contains random information in "7+13. DESCRIBE REACTION(S) continued" section. (Doc ID 2161555.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Argus Safety - Version 7.0.3 and later
Information in this document applies to any platform.

Symptoms

Draft CIOMS-I report contains random information in "7+13. DESCRIBE REACTION(S) continued" section.


Examples of random data generated:


7+13. DESCRIBE REACTION(S) continued
DECODE(CASE_PAT_HIST.ind_llt, NULL, CASE_PAT_HIST.ind_reptd, CASE_PAT_HIST.ind_llt || ' (' ||
CASE_PAT_HIST.indication || ')'), '') indication, decode(LM_CONDITION_TYPE.cond_category, 2,
DECODE(CASE_PAT_HIST.react_llt, NULL, CASE_PAT_HIST.react_reptd, CASE_PAT_HIST.react_llt || ' (' ||
CASE_PAT_HIST.reaction || ')') , '') reaction from CASE_PAT_HIST , CASE_MASTER , LM_CONDITION_TYPE where
case_master.case_id=c

7+13. DESCRIBE REACTION(S) continued
case_product.case_id=case_prod_drugs.case_id (+) and
case_product.seq_num=case_prod_drugs.seq_num (+) and
case_product.case_id=cpd.case_id (+) and case_product.seq_num=cpd.seq_num (+)
and case_master.case_id=case_study.case_id
(+) and case_prod_drugs.conc_units_id=ldu3.unit_id (+) and
CASE_PROD_DRUGS.FORMULATION_ID=LM_FORMULATION
.FORMULATION_ID (+) and case_product.pat_exposure = LM_P

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