FND (Foundation) Basic Tables in Oracle Apps R12
A quick reference guide to the core tables of the Application Object Library (AOL).
Understanding FND Tables
The FND (Foundation) schema, also known as the Application Object Library (AOL), contains the core tables that manage the underlying structure and security of Oracle E-Business Suite. These tables store crucial information about users, responsibilities, menus, concurrent programs, and more. Understanding these tables is essential for any technical or techno-functional consultant.
Key FND Tables
Here is a list of some of the most important and frequently used FND tables.
| Table Name | Description |
|---|---|
| FND_USER | Stores user account information, including username and password hashes. |
| FND_MENUS | Defines the navigation menus that users see in the application. |
| FND_FORM_FUNCTIONS | Contains information about functions (forms, pages, etc.) that can be called from menus. |
| FND_APPLICATION / FND_APPLICATION_TL | Stores information about registered applications and their translated names. |
| FND_CONCURRENT_PROGRAMS / FND_CONCURRENT_PROGRAMS_TL | Defines concurrent programs, their executables, and parameters. |
| FND_CONCURRENT_QUEUES / FND_CONCURRENT_QUEUES_TL | Manages the concurrent managers and queues that process requests. |
| FND_CONCURRENT_QUEUE_CONTENT | Defines which programs can be run by which concurrent managers. |
| FND_CONCURRENT_REQUESTS | Stores the history and status of all submitted concurrent requests. |