My Oracle Support Banner

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

Last updated on OCTOBER 01, 2018

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***


 AERS 4.5.1:

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

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
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 to;
  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.


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

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