FRM-40735, ORA-01422 When Opening Specific Cases in AERS
(Doc ID 1145414.1)
Last updated on APRIL 13, 2012
Applies to:Adverse Event Reporting System - Version: 188.8.131.52
Information in this document applies to any platform.
***Checked for relevance on 13-APR-2012***
FRM-40735 KEY-COMMIT trigger raised unhandled exception ORA-01422.
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "AERS1.AERS_DICTIONARY_API", line 574
ORA-06512: at "AERS1.AERS_DICTIONARY_API", line 986
The error does not occur for all AERS cases.
Running Batch Reclassify against these cases also results in the following errors returned:
Lock of case id:2007S1000002 failed with Lock manager error number:3.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!