My Oracle Support Banner

FRM-40735 Key-Commit Trigger Raised Unhandled Exception ORA-01403 (Doc ID 852244.1)

Last updated on JULY 03, 2019

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.