My Oracle Support Banner

CDA 4.0: Setting Up the Source System with Oracle Clinical 5.2.x Fails With ' ORA-00942: table or view does not exist ' (Doc ID 2811475.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Clinical Development Analytics - Version 4.0.0 and later
Information in this document applies to any platform.

Symptoms

CDA 4.0.0 -> Trying to add OC ( Oracle Clinical) as datasource, you are receiving the below error in ocda_oc_odi_driverscript<DATE>.log:


8. Enter values in the following fields:
- OC Source Server Host Name
- OC Source Server Port No
- OC Source Server Service Name
- OC Source System Password

9. Click Next.

10. Enter values in the following fields:
- OC Source Schema Name [RXC] -> the wrong step
- OC Source Schema Password

11. Click Next.
    The OCDA Oracle Clinical Source System Details screen appears.
    
12. Enter values in the following fields:
- OCDA OC Source Schema Name
- OCDA OC Source Schema Password
- OCDA OC Source Schema Confirm Password
- OCDA OC Default Tablespace Name
- OCDA OC Temporary Tablespace Name

13. Click Next.
    The OCDA Oracle Clinical Work Schema Details screen appears.
 
14. Enter values in the following fields:
- OCDA OC Work Schema Name
- OCDA OC Work Schema Password
- OCDA OC Work Schema Confirm Password
- OCDA OC Work Default Tablespace Name
- OCDA OC Work Temporary Tablespace Name

15. Click Next.
    The Summary screen appears
    
16. Click Install.

 

 

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.