Error Loading Who Drug 2009mar01 Dde+Hd Dictionary ORA-20000: 503600-Expired records cannot be deleted/updated

(Doc ID 820017.1)

Last updated on AUGUST 01, 2016

Applies to:

Adverse Event Reporting System - Version 4.5.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

***Checked for relevance on 10-MAY-2012***

Symptoms

AERS 4.5.1.x:
When attempting to execute below process to load the WHO Drug 2009Mar01 dictionary update using the AERS_TMS_UTILS package

For example:
exec AERS_TMS_UTILS.LoadWhodrug('WHODRUG',605,'1Q2009');


This is failing with the following error:

A Subsequent trace of the process and review of warning/error message showed a number of term updates were failing with  ORA-20000: 503600-Expired records cannot be deleted/updated messages, for example:

Cause

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