Actions --> Create New User Fails With ORA-01031 After Application of AERS iPatch 4.6.2.1 (Doc ID 1084496.1)

Last updated on JUNE 07, 2010

Applies to:

Adverse Event Reporting System - Version: 4.6.2 to 4.6.2 - Release: 4.6 to 4.6
Information in this document applies to any platform.

Symptoms

On : AERS 4.6.2.1

When attempting to create a new user via Actions --> Create New User, the following error is being returned after application of iPatch AERS 4.6.2.1

ERROR
-----------------------
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 909
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "AERS.AERS_CREATE_USER"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into AERS 4.6.2.1
2. Click on the Admin console link
3. Click on selected user group
4. Select Actions --> Create New User
5. Click on Create User





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