FRM-40735, ORA-01422 When Opening Specific Cases in AERS
Last updated on APRIL 13, 2012
Applies to:Adverse Event Reporting System - Version: 184.108.40.206
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.
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