Schema Validattion Differences in Insight 5.0.3 (Doc ID 1423656.1)

Last updated on FEBRUARY 27, 2012

Applies to:

Oracle Argus Insight - Version: 5.0.3 and later   [Release: 5.0 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

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