My Oracle Support Banner

OHF_run_etl_patch713.sh Failed With "ORA-00942: table or view does not exist" Error (Doc ID 2393146.1)

Last updated on JULY 19, 2018

Applies to:

Oracle Healthcare Foundation - Version 7.1.3 to 7.1.3 [Release 7.1]
Information in this document applies to any platform.

Symptoms

On : 7.1.2 version, Installer and configuration

When attempting to upgrade from OHF 7.1.2 to OHF 7.1.3, the following error occurs.

ERROR
-----------------------
Started the upgrade process by executing the script ohf_run_db_patch713.sh.
Step 1 succeeded.
Step 2 failed with following errors

W_EHA_SPECIMEN_METHOD_D W_EHA_SPECIMEN_METHOD_D,
  *
ERROR at line 89:
ORA-00942: table or view does not exist
  W_EHA_SPECIMEN_METHOD_D W_EHA_SPECIMEN_METHOD_D,
  *
ERROR at line 115:
ORA-00942: table or view does not exist
  ,W_EHA_RESEARCH_PATIENT_D
  *
ERROR at line 54:
ORA-00942: table or view does not exist

View created.

  ,W_EHA_RESEARCH_PATIENT_D
  *
ERROR at line 84:
ORA-00942: table or view does not exist

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) unzip -a ohf713_patch.zip.
Grant permissions as follows:

grant EXECUTE on ENT.ENTERPRISE_UTIL to CDM;
grant EXECUTE on ODB.ODB_UTIL to CDM;
grant INSERT on ODB.W_EHA_RSLT_STUDY to CDM;
grant SELECT on ENT.W_EHA_APPLICATION_SCHEMA to CDM;
grant SELECT on ENT.W_EHA_PRODUCT_VERSION to CDM;
grant SELECT on ODB.W_EHA_RSLT_STUDY to CDM;
grant SELECT on ODB.W_EHA_RSLT_STUDY_S to CDM;
grant UPDATE on ENT.W_EHA_PRODUCT_PROFILE to CDM;
grant UPDATE on ODB.W_EHA_RSLT_STUDY to CDM;

3) execute the script ohf_run_db_patch713.sh

 

Changes

 

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
Changes
Cause
Solution


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