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: 4.5.1.29
This problem can occur on any platform.

Symptoms

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.

STEPS TO REPRODUCE:

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

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