FRM-40735 Key-Commit Trigger Raised Unhandled Exception ORA-01403

(Doc ID 852244.1)

Last updated on AUGUST 12, 2016

Applies to:

Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.
***Checked for relevance on 04-FEB-2011***
***Checked for relevance on 31-Oct-2014***


Built a new AERS 4.6.1 instance based upon details found in Appendix B of the AERS 4.6 Installation manual entitled 'AERS Data Migration'.

After install, the new instance hits the following error when clicking 'Save' in Central Triage.
ie: Confirms it was not a duplicate case, then after clicking [OK] receive error window with text:

FRM-40735 KEY-COMMIT trigger raised unhandled exception ORA-01403.

ORA-01403: no data found

ORA-06512: at "TMS.TMS_DEF_INSTANCES_S1", line 8
ORA-06512: at "TMS.TMS_USER_FULLAUTOCODE", line 633
ORA-06512: at "TMS.TMS_USER_FULLAUTOCODE", line 756
ORA-06512: at "AERS1.AERS_DICTIONARY_API", line 734
ORA-06512: at "AERS1.AERS_DICTIONARY_API", line 854
ORA-06512: at "AERS1.AERS_DICTIONARY_API", line 1549
ORA-06512: at "AERS1.AERS_DICTIONARY_API", line 1899


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