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

Last updated on JULY 13, 2023

Applies to:

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

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