Important FND Tables in EBS

FND means foundation,all most all the oracle applications tables (CORE/TECHNOLOFY NOT BUSINESS) are build in this schema. You can think of this as a schema (APPLSYS). Some FND is also refered to AOL(Application Object Library).

FND_APP_SERVERS : This table will track the servers used by the E-Business Suite system.

FND_DATABASES : It tracks the databases employed by the eBusiness suite. This table stores information about the database that is not instance specific.

FND_DATABASE_INSTANCES : Stores instance specific information. Every database has one or more instance.

FND_ATTACHED_DOCUMENTS : Stores information relating a document to an application entity.

FND_DOCUMENTS : Stores language-independent information about a document.

FND_CURRENCIES : Stores information about currencies.

FND_LANGUAGES : Stores information regarding languages and dialects.

FND_TERRITORIES : Stores information for countries, alternatively known as territories.

FND_CONCURRENT_PROCESSES : Stores information about concurrent managers.

FND_CONCURRENT_PROCESSORS : Stores information about immediate (subroutine) concurrent program libraries.

FND_CONCURRENT_PROGRAMS(_TL) : Stores information about concurrent programs. Each row includes a name and description of the concurrent program.

FND_CONCURRENT_QUEUES : Stores information about concurrent managers.

FND_CONCURRENT_QUEUE_SIZE : Stores information about the number of requests a concurrent manager can process at once, according to its work shift.

FND_CONCURRENT_REQUESTS : Stores information about individual concurrent requests.

FND_CONCURRENT_REQUEST_CLASS : Stores information about concurrent request types.

FND_CONC_REQ_OUTPUTS : This table stores output files created by Concurrent Request.

FND_EXECUTABLES : Stores information about concurrent program executables.

FND_DESCRIPTIVE_FLEXS(_TL) : Stores setup information about descriptive flexfields.

FND_FLEX_VALUES : Stores valid values for key and descriptive flexfield segments.

FND_FLEX_VALUE_SETS : Stores information about the value sets used by both key and descriptive flexfields.

FND_LOOKUPS : Stores information about lookup types.

FND_LOOKUP_VALUES : Stores meaning values and codes for lookup types.

FND_MENUS(_TL) : It lists the menus that appear in the Navigate Window, as determined by the System Administrator when defining responsibilities for function security.

FND_MENU_ENTRIES : Stores information about individual entries in the menus in FND_MENUS.

FND_REQUEST_GROUPS : Stores information about report security groups.

FND_REQUEST_SETS : Stores information about report sets.

FND_RESPONSIBILITY(_TL) : Stores information about responsibilities.

FND_RESP_FUNCTIONS : Stores security exclusion rules for function security menus. Security exclusion rules are lists of functions and menus inaccessible to a particular responsibility.

FND_PROFILE_OPTIONS : Stores information about profile options.

FND_SECURITY_GROUPS : Stores information about security groups used to partition data in a Service Bureau architecture.

FND_USER : Stores information about application users.

FND_APPLICATION(_TL) : Stores applications registered with Oracle Application Object Library.

FND_SEQUENCES : Stores information about the registered sequences in your applications.

FND_VIEWS : Stores information about the registered views in your applications.

FND_TABLES : Stores information about the registered tables in your applications.