Query DCIs : FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-04063

(Doc ID 2284792.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Clinical - Version 4.5.1 to 5.1.0 [Release 4.5.1 to 5.1]
Information in this document applies to any platform.

Symptoms

Oracle Clinical migration was done from 4.5.1 to 5.1.

No DCI(s) can be queried from DCIs .

 

Steps:
=====

OC >> Definition >> DCIs >> DCIs

 

The initial error shown at the bottom of the screen is:

FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-04063

 

 

 

 

When we click the Exit button, three more errors pop up in this order:

FRM-41058: No such property for Get_Item_property

 

 


69790: Unexpected return item – Form will now exit

 

 


FRM-40105: Unable to resolve reference to item DCI_CTL_CTL.RETURN_FIELD

 

 

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