AERS 4.6.1 Patch Application SMQ Algorithm Warning ORA-20000: 245800-Record already exists. AERS_TMS_UTILS.AddExtDefIntQuery
(Doc ID 789962.1)
Last updated on FEBRUARY 14, 2022
Applies to:Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.
AERS 4.6.0 Installation of Patch 4.6.1
During the AERS Patch 22.214.171.124 installation the following step could not be executed successfully
due to an error related to the opa.messages table:
|SQL> exec aers_tms_utils.addextdefintquery ('AERSQRY','AERS QUERY', 'QUERY FOR AERS');
BEGIN aers_tms_utils.addextdefintquery ('AERSQRY','AERS QUERY', 'QUERY FOR AERS'); END;
ERROR at line 1:
ORA-20000: 245800-Record already exists.
ORA-06512: at "OPA.OPA_USER_MSG", line 302
ORA-06512: at "OPA.OPA_USER_MSG", line 375
ORA-06512: at "TMS.TMS_DEF_INT_QUERIES_M", line 99
ORA-06512: at "TMS.TMS_USER_DEF_EXT_SYSTEM", line 539
ORA-06512: at "TMSLOAD.AERS_TMS_UTILS", line 2245
ORA-06512: at line 1
These are set-up steps specific to SMQ Algorithms used in AERS
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