原文链接:http://www.hzhcontrols.com/new-355881.html

FND代表基础表,它是由AOL(应用对想库)、系统、管理员和模块表组成的,放在FND_TOP文件目录下。下面列出了一些关键的FND表,并进行了简单的描述他们的用法: ==FND_APPLICATION==:这个表,存储了所有注册在应用对象数据库中的应用对象信息,每个产品一条记录; ==FND_APPLICATION_TL==:TL表,跟语言相关,每多添加一种语言,该表的行数就就有FND_APPLICATION的几倍; ==FND_APP_SERVERS==:分别显示数据库server、应用server。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==:Stores information about concurrent programs. Each row includes a name and description of the concurrent program.并发程序的id、名称、更改时间等信息。 ==FND_CONCURRENT_PROGRAMS_TL==:Stores translated information about concurrent programs in each of the installed languages.根据语言,并发程序的id、名称、更改时间等信息。 ==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.单个并发请求的信息,包括请求id、请求名,请求状态 ==FND_CONCURRENT_REQUEST_CLASS==:Stores information about concurrent request types.(好像一直是空的) **==FND_CONC_REQ_OUTPUTS:This table stores output files created by Concurrent Request.并发请求产生的文件,比如pdf的,rtf的,excel的等等。 ==FND_EXECUTABLES==:Stores information about concurrent program executables. ==FND_DESCRIPTIVE_FLEXS==:Stores setup information about descriptive flexfields.存储描述性弹性域设置信息 ==FND_DESCRIPTIVE_FLEXS_TL==:Stores translated setup information about descriptive flexfields. ==FND_FLEX_VALUES==:Stores valid values for key and descriptive flexfield segments. ==FND_FLEX_VALUE_SETS==:Storesinformation about the value sets used by both key and descriptive flexfields.弹性域值集 ==FND_LOOKUPS== : Stores information aboutlookup types.存储查询类型信息; ==FND_LOOKUP_VALUES== :Stores meaning values and codes for lookup types.存储查询类型值和代码; ==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_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_PROFILE_OPTIONS==:Stores information about profile options.存储配置文件选项信息; ==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_USER==:Stores information about application users. ==FND_VIEWS==:Stores information about the registered views in your applications. ==FND_NODE==: 保存节点信息。