Thursday, September 19, 2013

[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



1 comment:

  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle BI Applications for eBusiness OBIA
    , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Oracle BI Applications for eBusiness OBIA. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/



    ReplyDelete