User Creation Problem In AERS FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06510 (Doc ID 1074411.1)

Last updated on AUGUST 08, 2017

Applies to:

Adverse Event Reporting System - Version 4.6.0 to 4.7 [Release 4.6.0 to 4.0]
Information in this document applies to any platform.

Symptoms

After a new AERS 4.6.x or 4.7.x Installation, when connecting to:

  • AERS
  • Administrator Console
  • Actions
  • Create New User 
After inputting the required data and then clicking to create user, the following error is raised in the application:

FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06510.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWSEC_API", line 527
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWSEC_OID", line 973
ORA-06512: at "PORTAL.WWSEC_OID", line 8227
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01403: no data found
ORA-06512: at "AERS1.AERSWW_PORTALIF", line 2570

Changes

New installation.

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