Monday, April 18, 2022

Oracle EBS Foundation Table

Oracle E-Business Suite (EBS) Foundation Tables

This post is 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.

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

 

No comments: