ADI REQUIRES A FNDFS_NODENAME ENTRY IN THE TNSNAMES.ORA FILE

ADI REQUIRES A FNDFS_NODENAME ENTRY IN THE TNSNAMES.ORA FILE [ID 2108008.6]
Modified 06-SEP-2006 Type BULLETIN Status PUBLISHED

SOLUTION DESCRIPTION
--------------------

You need to add an FNDFS entry to the TNSNAMES.ora file. This file is
usually found in the following location:

C:\ORANT\NETWORK\ADMIN


You need to do this because:

ADI is hardcoded to look for the FNDFS_nodename entry in the TNSNAMES.ora
file. When a Log or Output file is requested, ADI selects the node_name
from the FND_CONCURRENT_REQUESTS table, appends that value to FNDFS_ and
then looks in the TNSNAMES.ora file for 'directions' on what host to go
to and what port to ping for the FNDFS listener service.

Once the FNDFS listener service is found, the listener spawns a process
for the FNDFS executable based on the location given in the PROGRAM entry
for that service definition. The FNDFS executable takes the file name of
the log or output file, pulls that off of the file system on the server,
and sends back the raw data to the ADI application which parses the data
into a viewable report.

In Release 11 and forward, you are allowed to modify the RRA: Service
Prefix system profile to change the FNDFS_ to some other entry for
standard Oracle Applications. For example, you may want to use an entry
for REPORT_nodename instead of FNDFS_nodename. This will work for
Release 11/11i Applications, and also with ADI as from ADI 7.1.3


The following is a sample of the TNSNAMES.ora file:


TNSNAMES.ora
################
# Filename......: tnsnames.ora
# Client Profile: sample
# Date..........: 04-JUN-99 11:47:33
################
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#
PROD = #<---- this is the SERVICE NAME DESCRIPTOR
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = PROD) #<---- this is the name of the DB instance
(GLOBAL_NAME = PROD)
)
)
FNDFS_thisbox =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP)
(PROTOCOL = TCP)
(Host = thisbox)
(Port = 1521)
)
(CONNECT_DATA =
(SID = FNDFS)
)
)