My Oracle Support Banner

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

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

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
Symptoms
Cause
Solution

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