My Oracle Support Banner

Cannot Add or Remove ADMIN Role for an AERS User (Doc ID 729167.1)

Last updated on AUGUST 15, 2011

Applies to:

Adverse Event Reporting System - Version: 4.5.2 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 15-AUG-2011***


Cannot add the ADMIN role to an AERS user per Administrator Console


  • AERS
  • Administrator Console
  • Actions
  • Manage User Roles

See the Manage User Roles and select ROLE= ADMIN and try to assign..

This results in pop-up message:

FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception
ORA-6501: PL/SQL unhanded user-defined exception
ORA-6501: at PORTAL39.WWSEC_API, line 457
ORA-1403: no data found
ORA-6512: at "ENSITE.AERSWW_PORTALIF", line 2343


If try to remove the ADMIN privilege from existing user (ie: move right to left), getting error:

ORA-1919 Role Admin does not exist.


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.