User Creation Is Throwing Some Error In AERS 4.5. But The User Is Being Created - FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception (Doc ID 1331435.1)

Last updated on JUNE 13, 2016

Applies to:

Adverse Event Reporting System - Version: 4.5 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Goal


AERS 4.5

User Creation is throwing some errors in AERS 4.5 but the user is being created after closing out the window.

Errors are:




FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception
ORA-06510.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL30.WWSEC_API", line 457
ORA-01403: no data found
ORA-06512: at "AERS.AERSWW_PORTALIF", line 2372


After clicking on [OK] Administrator Console is shown and user e.g. AERSADMIN is created.


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