Search Results fnd_form

Overview

The FND_FORM table is a core Application Object Library (AOL) repository within Oracle E-Business Suite (EBS). It serves as the central registry for all application forms, which are the primary user interface components for data entry and inquiry. Every form developed and deployed in the EBS environment, from General Ledger journals to Purchase Order entry screens, must be registered in this table. This registration is fundamental to the security, navigation, and functional integration of the system. The table enables the association of forms with responsibilities, defines their executable properties, and allows them to be invoked via the menu system and function security.

Key Information Stored

The table's structure is defined by its primary and unique keys, which enforce critical business rules for form registration. The primary data elements stored include the APPLICATION_ID and FORM_ID, which together form the table's primary key (FND_FORM_PK). This composite key uniquely identifies every form within the entire EBS instance. The FORM_NAME, combined with APPLICATION_ID in the unique key FND_FORM_UK1, stores the internal name of the form executable (e.g., FNDSCAUS). While the provided metadata does not list all columns, typical columns in this table would also store the form's description, executable filename, parameters, and other attributes necessary for runtime execution and administration.

Common Use Cases and Queries

This table is central to system administration, security audits, and troubleshooting. Common use cases include identifying all forms available within a specific application, resolving form invocation errors, and auditing security assignments. A typical query retrieves form details by joining with FND_APPLICATION to get the application's name. For example, to list all forms in the 'Application Object Library' (APPLICATION_ID=0):

• SELECT f.form_name, f.form_id, a.application_short_name FROM apps.fnd_form f, apps.fnd_application_vl a WHERE f.application_id = a.application_id AND a.application_short_name = 'FND';

Another critical query involves verifying if a specific form is registered, which is often the first step in diagnosing a "Form not found" error when navigating from a menu.

Related Objects

As indicated by the foreign key relationships, FND_FORM is a foundational object referenced by several key AOL tables. FND_FORM_FUNCTIONS links forms to menu functions, enabling their inclusion in the navigation menu. FND_FORM_TL holds the translated names and descriptions for multilingual deployments. FND_LOGIN_RESP_FORMS uses it to define forms that are excluded from specific responsibilities. Furthermore, FND_ATTACHMENT_FUNCTIONS references it to control attachment functionality at the form level. The table itself references FND_APPLICATION to tie each form to its parent product application, ensuring proper namespace and organization.