FDM Can't Import From ERPI Error:"TNS ERROR : Couldn't connect to ERPI Database" (Doc ID 1470384.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.2.000 and later
Information in this document applies to any platform.

Symptoms

FDM 11.1.2.2
ERPI 11.1.2.2
When importing data from ERPi into FDM receiving an error "TNS ERROR Couldn't connect to ERPI"

The adapter log shows
System.Runtime.InteropServices.COMException (0x80040E37): ORA-00942: table or view does not exist
at ADODB.ConnectionClass.Execute(String CommandText, Object& RecordsAffected, Int32 Options)
at fdmErpiFin_E.clsDW.fConnectERPI(String ERPIdbServer, String ERPIdbPort, String ERPIdbUserID, String ERPIdbPW, String ERPIdbName, String ERPIdbProvider, String FDMdbUserID)

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