Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

fdm import data from ebs error, any helps?

Thread:using ERPI import data from EBS error occurred

Version

FDM 11.1.2.2

ODI 11.1.1.6

Oracle Database 11gR2;

ERPI and FDM was installed on the same machine(MS server 2008 64bit) and 32bit oracle db client as a plus;

Error MessageORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA

Error descriptionWhen import data to FDM application, data can import into ERPI database, but error occurred when push data into FDM application database.my ERPI database and FDM application database use the same SID.

tnsnames.ora config

odidev =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = odidev)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center