What are FND tables in Oracle Apps?

What are FND tables in Oracle Apps?

FND stands for foundation tables which is combination of AOL, SYSTEM, ADMINISTRATOR, MODULES tables and is placed under FND_TOP. Below i have listed few key FND tables that along with the little description of what is it used for : FND_APP_SERVERS : This table will track the servers used by the E-Business Suite system.

What does FND stand for Oracle?

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.

What is FND_USER table?

FND_USER table stores details about the Oracle E-Business Suite user-ids (Application Users) and related information (encrypted password, email-ids) etc.

What is AOL in Oracle Apps r12?

AOL is a collection of pre-built application components and facilities and it consists of forms, subroutines, concurrent programs and reports, database tables and objects, messages, menus, responsibilities, flex filed definitions, various guides and library functions.

What is Password_date in Fnd_user?

1) The password is maintained at FND_USER level (not portal single-signon). The PASSWORD_DATE column holds the date the current password was set. If the date present in the column it is interpreted as “User has changed the old password with the new password”.

How do I create a user backend in Oracle Apps?

Very simple procedures can be created which have this API used in it to create and add responsibility to the user. Step 1 : Simple procedure (anonymous block) to create a new user : DECLARE v_user_name VARCHAR2 (100) := upper(‘&Enter_User_Name’); v_description VARCHAR2 (100) := ‘NEW Test User’; BEGIN fnd_user_pkg.

What is value set in Oracle Apps?

Oracle E-Business Suite provides two predefined values sets, FND_STANDARD_DATE and FND_STANDARD_DATETIME that you can choose for your segments. These special values sets ensure that you enter a properly-formatted date, instead of any set of characters, in your flexfield segment.

What is assign responsibility to user in Oracle Apps r12 from backend?

In Oracle Applications, A responsibility can be added to a user using the “AddResp” procedure of “fnd_user_pkg”. the “AddResp” Procedure has the following Parameters. — You can use following api to add responsibility to the user you want. It — will prompt you for the username and responsibility name.

How do I add sysadmin responsibility to backend?

Query to add SysAdmin responsibility to a user

  1. USERNAME => ‘AMOHSIN’, — User Name —
  2. RESP_APP => ‘SYSADMIN’, — Apps Short Name.
  3. RESP_KEY => ‘SYSTEM_ADMINISTRATOR’, — Responsibility Key.

What is a Flexfield?

A flexfield is a flexible data field that your organization can customize to your business needs without programming. A key flexfield is a field you can customize to enter multi-segment values such as part numbers, account numbers, and so on.

What does FND stand for in Oracle apps?

Oracle FND Tables. FND Tables In Oracle Apps R12: AOL stands for Application Object Library and FND stands Foundation. It is data repository for your Oracle Applications. It keeps track of all application objects like users, Responsibilities, Menus, Applications, value sets, Lockups, Flex fields and Functions etc.

What are the FND tables in Oracle E Business Suite?

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.

Is the Oracle FND tables registered with AOL?

AOL is a part of the Applications Technology layer and, as the name suggests, AOL provides common functionality for all E-Business Suite products through a library of reusable database objects, programs, and code. Below are the tables and description. Stores applications registered with Oracle AOL.

What are the names of the FND tables?

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.

Back To Top