Autodeployment Fails Due to Invalid Object Check in Review Clinical Schema Recreation

(Doc ID 2361232.1)

Last updated on FEBRUARY 16, 2018

Applies to:

Oracle Health Sciences Central Designer - Version 2.1 and later
Information in this document applies to any platform.

Symptoms

 Autodeployment fails due to invalid object check in review clinical schema recreation.

The install clinical log will show something like:

VIEW  {view name} IS INVALID
BEGIN
*
ERROR at line 1:
ORA-20500: After Re-Compile 1 Object(s) Remain INVALID
ORA-06512: at "DBA<trial name>.REVIEWCHECKOBJECTS", line 34
ORA-06512: at line 2
----

 

 

 

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