In New Case Screen An Exception Is Raised For Soft Edit Checks (Doc ID 550386.1)

Last updated on FEBRUARY 25, 2008

Applies to:

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

Symptoms

-- Problem Statement:
On 4.5.1 in Production:
When entering new case and entered a value under the Received by which is not in the liat of Value
when the soft edit check screen appears and click on the Raise Query or Close option, the
following error occurs:

ERROR
FRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled exception
ORA-01403:
ORA-01403: no data found
ORA-06512 at"AERS.RPR_AE_DISCREPANCIES", line 14
ORA-04088 error during execution of triggers AERS.RPR_AE_DISCREPANCIES

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create a new case.
2. Go to Received By field and enter name that is not part of the LOV. Leave field.
When Soft Error Processing Options appear, select "Raise Query".

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