Reporting install fails with error ORA-00942 due to other tables in the trial DB schema that contain the string 'PF_' in the table name. (Doc ID 1585044.1)

Last updated on JUNE 20, 2014

Applies to:

Oracle Health Sciences InForm - Version 4.6.0 to 5.0.3 [Release 4.6.0 to 5.0.0]
Information in this document applies to any platform.

Symptoms

 Reporting install fails due to other tables in the trial DB schema.  One example error in the reporting install log is as follows:

Error when creating table PF_CONTROLDATA for dba<trial name>.                      

Error code -942 returned.                                                      

Error message is ORA-00942: table or view does not exist

ORA-02063: preceding  

line from <SID>                                                             

declare

*

ERROR at line 1:

ORA-20500: Reporting Installation Aborted.

ORA-06512: at line 94

 

 

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