Missing ACTIVESUBSTANCENAME error when opening E2B report
Last updated on AUGUST 07, 2017
Applies to:Oracle Argus Safety - Version 8.0 and later
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms