My Oracle Support Banner

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

Last updated on APRIL 26, 2021

Applies to:

Oracle Clinical - Version 4.6.0 and later
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

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
Symptoms
Cause
Solution
References


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