Oracle Clinical RDC 4.6.4 - ORA-00942: table or view does not exist (Doc ID 1396926.1)

Last updated on SEPTEMBER 26, 2012

Applies to:

Oracle Clinical Remote Data Capture Option - Version 4.5.1 to 4.6.3 [Release 4.5.1 to 4.6.0]
Information in this document applies to any platform.

Symptoms

This occurs after testing an OC 4.5.3 -> OC 4.6.4 upgrade. Try to log in to RDC 4.6.4 and you receive an error, with the log.xml file containing the following error messages:

<MSG_TEXT>&lt;![CDATA[Invalid login: user=ops$llsdk
JBO-30003: The application pool (oracle.pharma.rdc.model.services.RdcAMLocal) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=ORA-00942: table or view does not exist
ORA-06512: at "RXC.RDC_ZF_SURROUND", line 153
ORA-06512: at line 1
...

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