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

Goal

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

eg:

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


 

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

ORA-1919 Role Admin does not exist.

Solution

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