Views Created By The 'rxasravw.sql' Script Are Invalid After Upgrading to 4.6. (Doc ID 1076120.1)

Last updated on MARCH 22, 2010

Applies to:

Oracle Clinical - Version: 4.6 - Release: 4.6
Information in this document applies to any platform.

Symptoms

The following views (created by the rxasravw.sql script) show as Invalid Objects after upgrading
a replicated 4.5.3 instance to a stand-alone 4.6 instance :

ALL_ACCOUNT_PROGRAM_ACCESSES
ALL_CLINICAL_PROCEDURES
ALL_CLINICAL_STUDIES
ALL_CLIN_STUDY_ENROLL_CRITERIA
ALL_CLIN_ST_TERM_CRITERIA
ALL_COMBINED_TREAT_COMPONENTS
ALL_CONVERSION_SPECIFICATIONS
ALL_INVESTIGATORS
ALL_INVESTIGATORST
ALL_PRODUCT_MASTERS
ALL_PROGRAMS
ALL_PROGRAM_PRODUCT_MASTERS
ALL_PROJECTS
ALL_SITES
ALL_SITEST
ALL_STRATA
ALL_STRATUM_COMPONENTS
ALL_STUDIES
ALL_STUDY_REGIONS
ALL_STUDY_SITES
ALL_STUDY_SITEST
ALL_STUDY_SITE_ROLES
ALL_STUDY_SITE_ROLEST
ALL_STUDY_STRAT_FACTORS
ALL_TREATMENT_PATTERNS
ALL_TREATMENT_REGIMENS
ALL_TREAT_PATTERN_REGIMENS
AVAILABLE_CLINICAL_STUDIES

Cause

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