My Oracle Support Banner

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

Last updated on APRIL 22, 2021

Applies to:

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


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

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
.FORMULATION_ID (+) and case_product.pat_exposure = LM_P


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

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