My Oracle Support Banner

Reconciliation Report Completes with Failure Status In AERS 4.6.1 REP-300: Connection Description For Remote Database Not Found When Using Database Link (Doc ID 789007.1)

Last updated on OCTOBER 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 29-Aug-2014***

***Checked for relevance on 25-APR-2012***

Symptoms

The Oracle AERS 1st Pass Reconciliation report is Completing with Failure status e.g.

Terminated with error:
REP-300: connection description for remote database not found
SELECT AC . CASE_ID CASE_ID00 , AC . PATIENT_ID PATIENT_ID00 , AC . CENTER_ID CENTER_ID00 , AC .
INVEST_ID INVEST_ID00 , RPE . PATIENT_ID PATIENT_ID01 , RPE . CENTER_ID CENTER_ID01 , RPE .
INVEST_ID INVEST_ID01 , RPE . SERIOUS_FLAG_COUNT SERIOUS_FLAG



Steps To Reproduce:




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.