My Oracle Support Banner

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.

Symptoms

When CASE_PRODUCT. SDRUG_NOT_ADMIN has value -1, Reporting Rules do not run against the case and the report is not scheduled.


Steps--
-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.

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References


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