[EBS] Oracle E-Business Suite (EBS) Foundation Tables

 

 Oracle E-Business Suite (EBS) Foundation Tables

This is to simply a list of Oracle E-Business Suite (EBS) Foundation tables. The Foundation tables contain data that relate to the entire suite of applications – they are not specific to any one module.

Some foundation tables are used in Oracle BI Applications (OBIA), for example, the FND_USER, FND_USER_RESP_GROUPS, and FND_RESPONSIBILITY_VL tables are used in security-related Initialization Blocks.

In general, it’s good to be familiar with these tables when working on OBIEE projects with EBS as a source system.

Foundation Table	Purpose
FND_APPLICATION	Stores applications registered with Oracle Application Object Library.
FND_APPLICATION_TL	Stores translated information about all the applications registered with Oracle Application Object Library.
FND_APP_SERVERS	This table will track the servers used by the E-Business Suite system.
FND_ATTACHED_DOCUMENTS	Stores information relating a document to an application entity.
FND_CONCURRENT_PROCESSES	Stores information about concurrent managers.
FND_CONCURRENT_PROCESSORS	Stores information about immediate (subroutine) concurrent program libraries.
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_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_CURRENCIES	Stores information about currencies.
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_DESCRIPTIVE_FLEXS	Stores setup information about descriptive flexfields.
FND_DESCRIPTIVE_FLEXS_TL	Stores translated setup information about descriptive flexfields.
FND_DOCUMENTS	Stores language-independent information about a document.
FND_EXECUTABLES	Stores information about concurrent program executables.
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_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_SECURITY_GROUPS	Stores information about security groups used to partition data in a 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_VIEWS	Stores information about the registered views in your applications.
FND_USER_RESPONSIBILITY
FND_RESPONSIBILITY_VL
FND_ORACLE_USERID
FND_DATA_GROUP_UNITS