Oracle FND Tables

FND Tables In Oracle Apps R12:

AOL stands for Application Object Library and FND stands Foundation. It is data repository for your Oracle Applications. It keeps track of all application objects like users, Responsibilities, Menus, Applications, value sets, Lockups, Flex fields and Functions etc. AOL helps in building oracle applications and extensions to oracle applications. AOL is a part of the Applications Technology layer and, as the name suggests, AOL provides common functionality for all E-Business Suite products through a library of reusable database objects, programs, and code. Below are the tables and description.

Table Name	Table Description
FND_APPLICATION	Stores applications registered with Oracle AOL.
FND_APPLICATION_TL	Stores translated information about all the applications registered with Oracle AOL.
FND_CONCURRENT_PROCESSES	Stores information about concurrent managers.
FND_CONCURRENT_PROGRAMS	Stores information about concurrent programs. Each row includes a name and description of the concurrent program.
FND_CONCURRENT_PROGRAMS_TL	Stores translated information about concurrent programs in each of the installed languages.
FND_CONCURRENT_REQUESTS	Stores information about individual concurrent requests.
FND_CONC_REQ_OUTPUTS	This table stores output files created by Concurrent Request.
FND_CONCURRENT_REQUEST_CLASS	Stores information about concurrent request types.
FND_CURRENCIES	Stores information about currencies.
FND_DESCRIPTIVE_FLEXS	Stores setup information about descriptive flex fields.
FND_DESCRIPTIVE_FLEXS_TL	Stores translated setup information about descriptive flex fields .
FND_FLEX_VALUES	Stores valid values for key and descriptive flex field segments.
FND_FLEX_VALUE_SETS	Stores information about the value sets used by both key and descriptive flex fields.
FND_LOOKUPS	Stores information about oracle lookups.
FND_LANGUAGES	Stores information regarding languages and dialects.
FND_MENUS	It lists the menus that appear in the Navigate Window, as determined by the System Administrator when defining responsibilities for function security.
FND_MENUS_TL	Stores translated information about the menus in FND_MENUS.
FND_MENU_ENTRIES	Stores information about individual entries in the menus in FND_MENUS.
FND_PROFILE_OPTIONS	Stores information about user profile options.
FND_REQUEST_GROUPS	Stores information about report security groups.
FND_REQUEST_SETS	Stores information about report sets.
FND_RESPONSIBILITY	Stores information about responsibilities. Each row includes the name and description of the responsibility, the application it belongs to, and values that identify the main menu, and the first form that it uses.
FND_RESPONSIBILITY_TL	Stores translated 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_VIEWS	Stores information about the registered views in your applications
FND_SECURITY_GROUPS	Stores information about security groups used to partition data in Service Bureau architecture.
FND_SEQUENCES	Stores information about the registered sequences in your applications.
FND_TABLES	Stores information about the registered tables in your applications.
FND_TERRITORIES	Stores information for countries, alternatively known as territories.
FND_USER	Stores information about application users.
FND_DATA_GROUPS	Stores information about data groups in your AOL.
FND_FLEX_VALUE_HIERARCHIES	Stores information about child value ranges for key flex field’s segment values.

Download:

If you want to download the same above click here.