Imported AERS E2B Cases Are Missing The AE_REPORT_SOURCES.DISPLAY_NUM (Doc ID 783131.1)

Last updated on JANUARY 10, 2014

Applies to:

Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

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

Symptoms

Imported E2B files with Multiple Reports have a null display number for Reporters.

This results in a null Country Code Prefix for External Case IDs

Steps To Reproduce:

 

SELECT CASE_ID,
DISPLAY_NBR,
RPT_SEQ_NBR,
RPT_FRST_NAME FIRST,
RPT_LST_NAME LAST
FROM AE_REPORT_SOURCES
WHERE CASE_ID = upper('&Case_ID');

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