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

Last updated on JULY 13, 2023

Applies to:

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

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