E2B Performance Issue In An Environment With A Large Volume Of Cases (Doc ID 795222.1)

Last updated on APRIL 04, 2016

Applies to:

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

Symptoms

AERS 4.6.1.15
For AERS installations where there are high volumes of cases.

For example Case count is around 1 million.

An E2B Report run for a single case can take between 7 and 20 minutes to complete.


Steps To Reproduce:

  1. AERS 4.6.1.15
  2. Select an installation with a high number of cases in database e.g. 325000
  3. Run an E2B Report in either Draft of Submission Mode for a single case
  4. Report may take around 7-20 minutes to complete for a single case

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