FND Nodes – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
FND_NODES stores information about the nodes that are used to install and run Oracle Application at your site. Each row includes the name of the node and the platform code. The column name NODE_NAME is the given name used to refer to the machine or node at the site. The column PLATFORM_CODE specifies the make of the machine or node (e.g. DEC VMS, Sequent Ptx, etc.). This information is used to associate a concurrent manager with a specific node to support distributed processing.
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
None
Oracle EBS Tables Used
Report Categories
Related Reports
FND Profile Option Value Upload, FND Profile Option Values, FND Attached Documents, FND User Login History, FND Debug and Trace Settings, FND Attached Documents (Operating Unit Secured)
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Nodes 25-Aug-2024 000300.xlsx |
| Blitz Report™ XML Import | FND_Nodes.xml |
| SQL Source | FND Nodes.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-nodes/ |
Executive Summary
The FND Nodes report lists the application tier nodes (servers) registered in the Oracle EBS topology. It is a technical infrastructure report.
Business Challenge
- Infrastructure Audit: Verifying the list of active servers in a multi-node cluster.
- Concurrent Processing: Checking which nodes are configured to run concurrent managers.
- Cleanup: Identifying old or decommissioned nodes that need to be purged from
FND_NODES.
The Solution
This Blitz Report queries FND_NODES:
- Node Name: The hostname of the server.
- Platform: The operating system (e.g., Linux, Solaris).
- Status: Whether the node is active.
- Services: Which services (Web, Admin, Concurrent) are running on the node.
Technical Architecture
The report queries FND_NODES.
Parameters & Filtering
- None: Typically lists all nodes.
Performance & Optimization
- Small Data: Most systems have fewer than 20 nodes.
FAQ
- Q: Why do I see old servers here?
- A: If a server is decommissioned without running the
FND_CONC_CLONE.SETUP_CLEANroutine, it may remain in this table.
- A: If a server is decommissioned without running the
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH