How to Do a List of Values Lookup to Oracle Clinical Information in AERS

(Doc ID 756425.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Adverse Event Reporting System - Version 4.6.0 to 4.6.1 [Release 4.6.0]
Information in this document applies to any platform.

***Checked for relevance on 10-JAN-2014***


Opening case entry form and trying to select the LOV for study_id results in the below series of
errors (look-up being used is for Oracle Clinical Studies across a remote database link).

FRM-41072 Cannot create group OCL_STUDIES
FRM-41076 Error populating group
FRM-41085 Error getting group row count
FRM-40735 WHEN NEW FORM trigger raised unhandled exception
ORA 06502
ORA 01403
FRM 41086 Error getting group selection count
FRM- 40733 GET GROUP SELECTION count failed

Steps to Reproduce:


  1. AERS 4.6.1
  2. Separate OC installation Database
  3. A Database Link exists to the OC installation.
  4. A Code List / Record Group has been created with a look-up to
  5. CLINICAL_STUDY_VERSIONS in the remote Database.
  6. The query runs fine through the back-end.
  7. Opening case entry form and trying to select the List of Values (LOV) from study_id results in the series of errors mentioned above.


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