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

Last updated on OCTOBER 05, 2009

Applies to:

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

Symptoms

Adverse Event Reporting System (AERS) iPatch 4.6.1.4:

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

ERROR
FRM-40735 DRUG_LABELING trigger raised unhandled exception
ORA-01779.
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

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