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:

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

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