FRM-40735, FRM-40815, and FRM-92101 errors generated after login to AERS 4.5.1 having applied the patches 4.5.1.29 through 4.5.1.49 (Doc ID 559086.1)

Last updated on APRIL 01, 2016

Applies to:

Adverse Event Reporting System - Version 4.5.1 and later
Information in this document applies to any platform.
***Checked for relevance on 05-JUL-2010***
***Checked for relevance on 03-FEB-2012***
***Checked for relevance on 29-Aug-2014***

Symptoms

 AERS 4.5.1:

When attempting to start AERS application as SUPERUSER after patches 4.5.1.29 to 4.5.1.49 were
applied, the following errors occur:

ERROR
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-04067.
ORA-01403: no data found

FRM-40815 Variable GLOBAL.DE_VIEW_ONLY does not exist
FRM-40815 Variable GLOBAL.VERSION_NO does not exist
FRM-40815 Variable GLOBAL.USER_NAME does not exist
FRM-40815 Variable GLOBAL.G_SUPERVISOR_FLAG does not exist
FRM-92101: A failure has occurred on the Server. You will need to reestablish your session.



The errors generated in trace files are as follows:

ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
ORA-06512: at line 7

ORA-01403: no data found
ORA-04067: not executed, package "ENSITE.POPULATEQTEMP" does not exist.

When trying to access "Help"/"About Oracle AERS" from application menu, instead of Oracle AERS
Component Versions is displayed the message:

"Oracle AERS Front-end version 4.5.1.48
Other Component Versions not available before log on".
"User Group ID: << Version and User Info not available before log on >> "




The issue can be reproduced at will with the following steps:

  1. Apply patches 4.5.1.29 to 4.5.1.49;
  2. Login to AERS application as SUPERUSER;
  3. Verify the error messages generated in Case Entry page;
  4. Verify the error messages generated in Case Browse page;
  5. Try to access "Help"/"About Oracle AERS" from application menu and verify the message displayed in About Oracle AERS window.

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