FRM-40202: Field Must be Entered Error in Data Discrepancies Screen

(Doc ID 369918.1)

Last updated on SEPTEMBER 22, 2008

Applies to:

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

"Checked for relevance on 22-Sep-2008"


Receive the following error(s) when trying to enter and save Data Discrepancies for any case:

FRM-40202 Field must be entered

1. Within AERS, open a case
2. Go to the Case Info menu and select Discrepancies
3. Within the Data Discrepancies form, add a new record or arrow down to create a new record
    Note: the Status, Source, Type and Rule Name all populate automatically
4. Enter in the Description and Comment
5. Click on the Save icon

At the point of Save numerous 'FRM-40202 Field must be entered' error messages appear.
These will clear eventually. However you cannot save the record until you put an entry in the 'Table Name' and 'Column Name' fields.

There are no LOVs attached to this field and AERS will allow you to enter anything in these fields, not necessarily a valid table and column name. Once there is an entry in these fields then the record can be saved.


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