Insight Not Enforcing All Data Integrity Checks As Per Insight Administrator Guide
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.
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
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