ORA-1722 Invalid Number. Occurring For All Cases - Trying To Close Any Case (Doc ID 1444854.1)

Last updated on FEBRUARY 08, 2015

Applies to:

Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Feb-2015***

Goal

Running into the below pop-up message window when saving changes during case close.
 This is happening to all cases in the database.
FRM-40735 WHEN-WINDOW-CLOSED trigger raised unhandled exception
ORA-1722
ORA-1722: Invalid number
ORA--6512 at 'validation_aers_dictionary_api, line 3910

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