My Oracle Support Banner

Updating Dictionaries with New Dictionary Versions (Doc ID 472090.1)

Last updated on JANUARY 13, 2017

Applies to:

Adverse Event Reporting System - Version 4.6.0 to 4.6.1 [Release 4.6.0]
Information in this document applies to any platform.
Information in this document applies to any platform.
***Checked for relevance on 07-Aug-2015***


DESCRIPTION: This Alert provides information on how you update your dictionaries, specifically MedDRA, WHO-Drug, MedDRA-J, and MHLW, to the latest versions. Appendix A of the Oracle AERS Installation Guide currently includes instructions for updating the MedDRA and WHO-Drug dictionaries, however, there are some additional steps that this Alert provides. These instructions will replace the existing instructions in the next revision of the Installation Guide (AERS 4.7). This Alert serves as initial instructions for updating the MedDRA-J dictionary and MHLW dictionary, and will be added to the next revision of the Installation Guide (AERS 4.7).

ASSUMPTIONS: It is assumed that you have already installed baseline versions of the dictionaries using the Oracle AERS Installation Guide. You must apply the patch PRIOR to performing these steps.

NOTE: Please refer to the Oracle AERS Installation Guide for instructions on obtaining the necessary information that you need to perform the upgrades. Specifically, you will need the TMSLOAD user, Activation Group, and Dictionary Short Names.

PREREQUISITES: Before using these instructions to update your dictionaries, you must create or recreate the TMSLOAD user:

NOTE: The <tmsload_user_name> name must be in caps. "TMSLOAD" is used as the default for <tmsload_user_name>.

From SQL*Plus, execute the following from OPA_HOME\aers\database\configuration\tms



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.