FND 和 AOL 的概念

在试图了解FND之前，我们先了解另外一个概念： Oracle E-Business Suite technology layer

The Oracle E-Business Suite technology layer lies between the Oracle E-Business Suite technology stack（TXK） and the Oracle E-Business Suite product-specific modules. It provides features common to all Oracle E-Business Suite products.

也就是technology layer处在TXK 和 产品模块之间，用来提供ebs的产品特征。而FND是technology layer的关键组件：

technology layer 包括了： 

• Oracle Applications DBA (AD)
• Oracle Application Object Library (FND)
• Oracle Applications Utilities (AU)
• Oracle Common Modules (AK)
• Oracle Workflow (WF)
• Oracle Web Applications Desktop Integrator (BNE)
• Oracle Alert (ALR)
• Oracle Application Framework (FWK)
• Oracle BI Publisher (XDO)

What does FND mean?

FND means foundation. So you can think of what a foundation means, all most all the oracle applications tables (CORE/TECHNOLOFY NOT BUSINESS) are build in this schema. You can think of this as a schema (APPLSYS). Some FND is also refered to AOL(Application Object Library).

Oracle Application Object Library (FND)：
The Oracle Application Object Library is a key component of the Oracle E-Business Suite technology layer. It consists of a collection of reusable code, programs,and database objects that provides common functionality across all products.Oracle Application Object Library offers many features to make system administration easier, such as security setup and maintenance, and management of concurrent processing. Using Application Object Library ensures that the processing of flexfields or the procedure for report submission, for example, does not vary from one product to another. Oracle Application Object Library also provides capabilities for developers to extend the operation of Oracle E-Business Suite by allowing the creation of custom programs that interact with the base modules.

FND是technology layer的一个关键组件，它提供了一系列的可重用的程序代码、数据库对象 来为所有的产品提供常用功能，Oracle Application Object Library(FND)提供许多特性简化了管理工作，比如安全创建 比如管理 比如并发程序管理。

FND同时也为开发者提供扩展ebs标准功能的能力，开发者可以开发出于基础模块交互的程序。

可以通过以下脚本查询FND_xxx表的意思：

SELECT application_id, 
table_id, 
table_name, 
user_table_name, 
description 
FROM fnd_tables 
WHERE table_name LIKE UPPER('%&table_name%');

Note: Enter the table_name for which you want to find out details. You can put  application_id to filter tables.


Reference: [Taken from http://oracleappstechnology.blogspot.com/2009/02/good-queries-on-fnd-tables-for-apps11i.html（我把这篇文章放在了：http://blog.youkuaiyun.com/cymm_liu/article/details/25562613）]

Please see this, If its helpful. 

http://www.blogcatalog.com/blog/knoworacle/8b60656ab24e8ea7a98f241fe2ba746d
http://freshers-oracleapplications.blogspot.com/2008/09/fnd-tables.html
http://www.club-oracle.com/articles/oracle-apps-fnd-and-concurrent-manager-key-tables-267/

What is the meaning of FND in AOL?

The meaning of FND in  Oracle  Apps or in AOL(Application Object Library) is system name of core application object library and now it is renamed to Application Technology. The application has $FND_TOP which has all the apps related product files。

FND Stands for Foundation in Application Object Library Module.
Most of the tables in AOL module starts with fnd_XXXX .