My Oracle Support Banner

Drug Labeling Does not Work After applying AERS iPatch (Doc ID 557737.1)

Last updated on OCTOBER 05, 2009

Applies to:

Adverse Event Reporting System - Version:
This problem can occur on any platform.


Adverse Event Reporting System (AERS) iPatch

When attempting to execute the Drug Labeling option under the Action Menu,
the following error occurs:

FRM-40735 DRUG_LABELING trigger raised unhandled exception
ORA-01779: cannot modify a column which maps to a non key-preserved table
ORA-06512: at "AERS1.CASEENTRY" , line 310

Steps To Reproduce:

The issue can be reproduced at will with the following steps:

  1. Open a case/create a new case
  2. Click on the Event Screen
  3. Select Action/Drug Labeling


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.