Query Of Field Event-To-Product Company Relatedness: Throws Error: En-20144: Col1 Is Not A Valid Code

(Doc ID 453641.1)

Last updated on SEPTEMBER 24, 2007

Applies to:

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


While attempting to execute a QUERY EVENTS after entering the value 'COL1' in the 
Event-To- Product-Company-Relatedness window. Instead of returning the expecting records the following error message is thrown:

ERROR MESSAGES: Error EN-20144: Col1 is not a valid code. Double click in the field to see a list of valid codes.


1. Open AERS
2. Click 'Query Cases'
3. Navigate to 'Events' query window
4. Enter 'Col1' in the 'Event-To-Product Company Relatedness' column
5. Click on 'Retrieve cases' in the tool bar
6. Error message is displayed in the console

OCCURRENCE PATTERNS: always when attempting to query when the value entered into the ‘Event-To-Product Company Relatedness’ column is not valid


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