Report Does Not Fire For Suspect Product With CASE_PRODUCT.SDRUG_NOT_ADMIN = -1
(Doc ID 2796995.1)
Last updated on MAY 20, 2022
Applies to:Oracle Argus Safety - Version 8.2.2 and later
Information in this document applies to any platform.
When CASE_PRODUCT. SDRUG_NOT_ADMIN has value -1, Reporting Rules do not run against the case and the report is not scheduled.
-Import XML Files and accept imported XML from Incoming ICSR to create case
-Execute the following:
SDRUG_NOT_ADMIN will have value -1 after import.
The clause " ( nvl(cfg_reg_report_rules.sdrug_non_admin, 0) = 1 OR
nvl(case_product.sdrug_not_admin, 0) = 0 )" is present in the main report scheduling sql
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