My Oracle Support Banner

Schema Validattion Differences in Insight 5.0.3 (Doc ID 1423656.1)

Last updated on JULY 13, 2023

Applies to:

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

Goal

When upgrading from Insight 5.0.2 to 5.0.3, there are extra table columns for the DM_INTAKE_DETAILS table listed in the Schema Validation log for 5.0.3.   Are these extra columns truly expected?

EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS CASE_TYPE VARCHAR2 90 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS COUNTRY_OF_INCIDENCE VARCHAR2 150 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS EVENT_PT VARCHAR2 765 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS EVENT_VERBATIM VARCHAR2 750 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS FLTH_WL VARCHAR2 30 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS PRODUCT_NAME VARCHAR2 210 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS REPORTER_TYPE VARCHAR2 90 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS SITE VARCHAR2 120 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS STUDY_ID VARCHAR2 105 Y
EXTRA TABLE COLUMNS UNDER APR_MART DM_INTAKE_DETAILS SUR VARCHAR2 30 Y
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS CASE_TYPE VARCHAR2 90
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS COUNTRY_OF_INCIDENCE VARCHAR2 150
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS EVENT_PT VARCHAR2 765
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS EVENT_VERBATIM VARCHAR2 750
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS FLTH_WL VARCHAR2 30
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS PRODUCT_NAME VARCHAR2 210
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS REPORTER_TYPE VARCHAR2 90
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS SITE VARCHAR2 120
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS STUDY_ID VARCHAR2 105
EXTRA TABLE COLUMNS UNDER APR_MART V_DM_INTAKE_DETAILS SUR VARCHAR2 30

Solution

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
Goal
Solution


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