Insight Not Enforcing All Data Integrity Checks As Per Insight Administrator Guide (Doc ID 1940249.1)

Last updated on OCTOBER 31, 2014

Applies to:

Oracle Argus Insight - Version 7.0.4 and later
Information in this document applies to any platform.

Goal

As per Insight Administrator Guide the following data integrity checks are mentioned

Data Integrity Checks Before ETL

Argus must complete the following data integrity checks before performing the ETL:
■Every case must have at least one suspect product.
■Every case must have at least one event where the DESC_REPTD column is not null.
■Every case must have one and only one primary event.
■Every case must have a State record (CASE_MASTER.STATE_ID).
■Every case must have a Report Type record (CASE_MASTER.RPT_TYPE_ID).
■Every case must have a Country of Incidence record (CASE_MASTER.COUNTRY_ID).
■Every case must have a Study record (CASE_STUDY).
■Every case must have an Assessment record (CASE_ASSESS).
■Every product in CASE_PRODUCT must have a record in CASE_PROD_DRUGS.
■If there are reporters on the case, there must be only one primary reporter

We have observed cases being rejected by Insight for multiple primary events and multiple primary reporters. However we have found cases in Argus without any suspect products. Can you confirm which of the above 10 data integrity checks are enforced by insight
 

Solution

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