Skip to content

FND Form Functions

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

FND Form Functions

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
FND Form Functions.sql
FND Form Functions.sql
 
 
README.md
README.md
 
 

README.md

layout default
title FND Form Functions | Oracle EBS SQL Report
description – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Form, Functions, fnd_form_functions_vl, fnd_application_vl, fnd_form_vl
permalink /FND%20Form%20Functions/

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

Enginatics

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

© 2026 Enginatics