My Oracle Support Banner

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

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
  References

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