FND Form Functions – 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
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
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
Blitz Report Assignments and Responsibilities, 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
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 Form Functions 21-Jul-2017 172941.xlsx |
| Blitz Report™ XML Import | FND_Form_Functions.xml |
| SQL Source | FND Form Functions.sql |
| Full Report 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
© Enginatics GmbH