FND Form Functions – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
None
Report Parameters
Function Name, User Function Name like, Function Type, Form Application Name, Form Application Short Name, Form Name, User Form Name, Responsibility Name, HTML Call contains
Oracle EBS Tables Used
fnd_form_functions_vl, fnd_application_vl, fnd_form_vl
Report Categories
Related Reports
FND Menu Entries, FND Forms Personalizations, FND Responsibility Access, FND Attachment Functions, FND User Login History, FND FNDLOAD Object Transfer, FND Responsibility Menu Exclusions
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Form Functions 21-Jul-2017 172941.xlsx |
| Blitz Report™ XML Import | FND_Form_Functions.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-form-functions/ |
Executive Summary
The FND Form Functions report documents the registered functions in Oracle EBS. A “Function” is the basic unit of application logic (a form, a web page, or a sub-function) that can be assigned to a menu.
Business Challenge
- Security Analysis: Identifying which functions invoke a specific Form or HTML page.
- Menu Construction: Finding the correct function name to add to a new custom menu.
- Web vs. Form: Distinguishing between OAF (HTML) functions and Oracle Forms functions.
The Solution
This Blitz Report lists the function details:
- Function Name: The internal developer name.
- User Function Name: The friendly name seen in menus.
- Type: Form, Subfunction, JSP, etc.
- Form/HTML Call: The actual code or form executable being invoked.
Technical Architecture
The report queries FND_FORM_FUNCTIONS_VL and joins to FND_FORM_VL to show the linked form (if applicable).
Parameters & Filtering
- Function Name: Search by internal name.
- HTML Call contains: Useful for finding all functions that point to a specific JSP page or OAF region.
Performance & Optimization
- Fast Execution: Runs quickly against the metadata tables.
FAQ
- Q: What is a “Subfunction”?
- A: It is a function that doesn’t open a screen but grants permission to a specific button or logic within a screen (Function Security).
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
© 2026 Enginatics