Friday, September 11, 2009

RRA/FNDFS



Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files. 



FNDFS executable uses the Report Review Agent Listener in the 8.0.6 Oracle Home installed on the application tier.

The report review agent uses two major configuration files :

1) listener.ora

2) tnsnames.ora

Location of these files -- $ORACLE_HOME/network/admin

FNDFS listener is automatically configured by the system.

When a user makes a request to view a report, FNDFS program is launched.

FNDFS connectivity can be configured by configuring the tnsnames.ora file.

Location of tnsnames.ora file -- $TNS_ADMIN/tnsnames.ora

An alias is created for FNDFS_nodename.

The tnsnames.ora file defines connections to the FNDFS listener adn it contains the address list of all the services that we can connect to from the client.

FNDFS_nodename=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)
(HOST=hostname)
(PORT=portnumber))
(CONNECT_DATA=(SID=FNDFS))
)

No comments: