Missing ACTIVESUBSTANCENAME error when opening E2B report (Doc ID 2275467.1)

Last updated on AUGUST 07, 2017

Applies to:

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

Symptoms

There is a Missing ACTIVESUBSTANCENAME error when generating E2B report for
WHO-DD drugs which do not have Ingredient.

There are 1000+ of such drugs in WHO-DD dictionary that could be found by sql
select DRUG_NAME from WHODRUG.WHO_DRUG_DICT where DRUG_RECORD_NUMBER not in
(select DRUG_RECORD_NUMBER from WHODRUG.WHO_INGREDIENTS)

All E2B reports containing WHO-DD drug from that list are affected.

Steps to Repeat:
----------------
1) Create a case containing WHO-DD drug without ingredient.
2) Generate E2B report



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