Missing Objects Found In Argus Safety Database While Performing Schema Validation (Doc ID 1928174.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

There are lot of missing objects in the schema validation log

1. MISSING OBJECTS UNDER ARGUS_APP   INDEX  IEFN_CSM_CASE_NUM

2.DISCREPANCIES TABLE_NAME COL_NAME COL_DATA_TYPECOL_DATA_LENGTH COL_DATA_PRECISION COL_DATA_SCALE C
====================================================================================================
DISCREPANCIES TABLE_NAME COL_NAME COL_DATA_TYPE COL_DATA_LENGTH COL_DATA_PRECISION COL_DATA_SCALE C
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_ASSESSEVENT_PRIMARY_JVARCHAR21600 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT SC_OTHER_TEXTVARCHAR2 120 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT_CONSEQUENCE CONSEQUENCEVARCHAR2 400 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT_CONSEQUENCE CONSEQUENCE_JVARCHAR2 400 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT_CONSEQUENCE TERM VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT_CONSEQUENCE TERM_J VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT_DETAILONSET_DELAYVARCHAR2 160 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT_DETAILONSET_LATENCYVARCHAR2 160 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_EVENT_DETAILOTHER_INFORMATIONVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_PMDA_LICENSEPMDA_NUMBERVARCHAR2 400 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_PROD_DEVICESIMPLANT_DURATION VARCHAR280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_WORKLISTCOUNTRY_JVARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_WORKLISTDESC_REPTD_J VARCHAR21020 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_WORKLISTPREF_TERM_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_WORKLISTPRODUCT_NAME_J VARCHAR2 280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_WORKLISTREPORTER_TYPE_JVARCHAR2 120 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CASE_WORKLISTSTUDY_NUM_JVARCHAR2 140 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_COPY_CATEGORYCATEGORY_NAMEVARCHAR2 240 N
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE ADDRESSVARCHAR2 400 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE ALT_PHONEVARCHAR280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE CITY VARCHAR2 140 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE COUNTRYVARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE DEPARTMENT VARCHAR2 240 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE EMAILVARCHAR2 400 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE ENTERPRISE_ABBRV VARCHAR280 N
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE ENTERPRISE_NAMEVARCHAR2 240 N
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE FAXVARCHAR280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE FIRST_NAME VARCHAR2 140 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE LAST_NAMEVARCHAR2 140 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE MIDDLE_NAMEVARCHAR260 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE PHONEVARCHAR280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE POSTAL_CODEVARCHAR260 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE PREFIX VARCHAR240 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_ENTERPRISE STATEVARCHAR2 160 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_PER_DELIV_QTY_JDELIV_QTYVARCHAR248 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP CFG_PER_DELIV_QTY_JPROD_NAMEVARCHAR2 280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS CASE_TYPEVARCHAR2 120 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS COUNTRY_OF_INCIDENCE VARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS EVENT_PT VARCHAR21020 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS EVENT_VERBATIM VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS FLTH_WLVARCHAR240 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS PRODUCT_NAME VARCHAR2 280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS REPORTER_TYPEVARCHAR2 120 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS SITE VARCHAR2 160 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS STUDY_ID VARCHAR2 140 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP INTAKE_DETAILS SURVARCHAR240 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LAM_EVENTOTHER_TEXT VARCHAR2 120 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE AUTHOR VARCHAR2 800 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE DOC_NUMVARCHAR280 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE FAMILY_UPDATE_NOTESVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE ISSUEVARCHAR260 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE JOURNALVARCHAR2 320 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE PAGESVARCHAR2 120 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE REJECT_NOTES VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE SEARCH_EQ_NUMVARCHAR240 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE TITLEVARCHAR21000 N
MISSING TABLE COLUMNS UNDER ARGUS_APP LIT_INTAKE VOLUME VARCHAR260 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_CODED_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_HLGT_J VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_HLT_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_LLT_CODE_J VARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_LLT_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_PT_TERM_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_REPTD_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_ALWAYS_SERIOUS_TERM AST_SOC_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_EVT_CONSEQUENCE CONSEQUENCEVARCHAR2 400 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_EVT_CONSEQUENCE TERM VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_IMPROPER_USEIMPROPER_USE_J VARCHAR2 120 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_INSTITUTION INSTITUTIONVARCHAR2 240 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_INSTITUTION INSTITUTION_ID VARCHAR260 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_INSTITUTION INSTITUTION_JVARCHAR2 240 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_AS_CODEDVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_AS_CODED_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_AS_REPTDVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_AS_REPTD_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_HLGTVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_HLGT_CODE VARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_HLGT_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_HLT VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_HLT_CODEVARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_HLT_J VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_LLT VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_LLT_CODEVARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_LLT_CODE_JVARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_LLT_J VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_SOC VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_SOC_CODEVARCHAR2 200 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LABELED_TERMS TERM_SOC_J VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LAB_TEST_TYPESTEST_CODED_J VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LAB_TEST_TYPESTEST_REPTD_J VARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LIC_CATEGORYCATEGORY VARCHAR2 800 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LIC_CATEGORYCATEGORY_J VARCHAR2 800 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LITERATURE_TYPE TYPE VARCHAR2 160 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_LITERATURE_TYPE TYPE_J VARCHAR2 160 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_PMDA_REPORT_TYPEPMDA_REPORT_TYPE VARCHAR2 120 N
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_PMDA_REPORT_TYPEPMDA_REPORT_TYPE_J VARCHAR2 120 N
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_PRODUCT IND_CODED_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_PRODUCT IND_REPTD_JVARCHAR21000 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_RPT_CATEGORYDESCRIPTIONVARCHAR2 800 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_RPT_CATEGORYDESCRIPTION_JVARCHAR2 800 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP LM_RPT_CATEGORYRPT_CATEGORY VARCHAR212 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP MEDDRA_SYNONYMSSYNVARCHAR21020 N
MISSING TABLE COLUMNS UNDER ARGUS_APP MEDDRA_SYNONYMSSYN_JVARCHAR21020 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP PDP_QUEUE_E2BPI_BINDED_VARIABLESVARCHAR2 800 Y
MISSING TABLE COLUMNS UNDER ARGUS_APP PDP_QUEUE_E2BPI_SENDING_AGENCYVARCHAR2 400 Y

Changes

Cause

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