Oracle Application Short Names

SELECT fa.application_id           "Application ID",
       fat.application_name        "Application Name",
       fa.application_short_name   "Application Short Name",
       fa. basepath                 "Basepath"
  FROM fnd_application     fa,
             fnd_application_tl  fat
 WHERE fa.application_id = fat.application_id
 AND fat.language      = USERENV('LANG')
 ORDER BY fat.application_name;

APPLICATION SHORT NAME                APPLICATION NAME
1. FND                                                       Application Object Library
2. OFA                                                       Assets
3. BOM                                                     Bills of Material
4. IBC                                                        Content Manager
5. ODQ                                                       Data Query
6. ZX                                                          E-Business Tax
7. EDR                                                        E-Records
8. POM                                                       Exchange
9. GL                                                           General Ledger
10. INV                                                        Inventory
11. MFG                                                      Manufacturing
12. WPS                                                     Manufacturing Scheduling
13. MRP                                                     Master Scheduling/MRP
14. OE                                                         Order Entry
15. ONT                                                       Order Management
16. AP                                                           Payables
17. IBY                                                         Payments
18. PAY                                                         Payroll
19. PJM                                                        Project Manufacturing
20. PA                                                           Projects
21. PN                                                           Property Manager
22. PO                                                           Purchasing
23. QA                                                           Quality
24. AR                                                           Receivables
25. WSH                                                       Shipping Execution
26. XLA                                                        Subledger Accounting

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.

Application Object Library (AOL) in Oracle Apps R12

AOL mainly contains three things:

• Operating profiles (System Profiles)
• Application security (User, Function, and Responsibility Security)
• Concurrent Processing (Concurrent manager, request, program, process)

AOL is a powerful library having components of code (objects) used in one or more applications. 

AOL contains the following components:

• Users
• Responsibilities
• Request Group
• Request Sets
• Concurrent Programs
• Concurrent Managers
• Concurrent Program Executables
• Value Sets
• Flex Fields
• Form and Functions
• Menus
• Messages
• Table Registration
• Profiles
• Data Group

Responsibility

• It is nothing but a collection of three things – menu, data group, and request group which is attached to a specific user as per his/her level of access.

Request Group

• A request group is a collection of concurrent programs or request sets. It is attached to a responsibility to control the user’s access to concurrent programs/requests.

Request Set

• A request set is a collection of reports and/or programs that you group together. You can submit the reports and/or programs in a request set all at once using a single transaction.

Concurrent Program

• A concurrent program is a program that does not require continued interaction on your part to perform a specific task. In Oracle Applications, for example, the concurrent program may be a program written to create a report or to post a batch of general ledger journal entries.

Concurrent Manager

• The concurrent manager is a component of concurrent processing that monitors and runs tasks without tying up your computer.

Concurrent Process

• The concurrent process is an instance of a running concurrent program. Each time a concurrent manager receives a request and runs a concurrent program, it creates a new concurrent process. A concurrent process can run simultaneously with other concurrent processes

Concurrent Request

• The concurrent request is a request that you submit to run a concurrent program as a concurrent process.

Value Set

• A set of predefined or validated values assigned to a field (parameter) that restricts the user to enter from entering invalidated data.

Menu

• A  menu is a hierarchical arrangement of functions and menus of functions that appears in the Navigator.
• A  menu entry is a menu component that identifies a function or a menu of functions.
• Each responsibility has a menu assigned to it.

Functions

• A function is a set of Oracle Applications that is executed only if the name of the function is present in a list maintained within a responsibility.
• Because all users should not have access to every business function in a form, Oracle Applications provide the ability to identify pieces of applications logic as functions.
• Function security lets you restrict application functionality to authorized users.

Data Group

• The data group is a collection of pairings of Applications with Oracle ID.
• An Oracle ID is a username and password that allows access to application tables in an Oracle database.
• Concurrent managers use a data group to match the application that owns a report or concurrent program with a unique Oracle ID.

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.

Oracle Apps AOL (Application Object Library) Overview & Key Concepts

https://drive.google.com/open?id=1cs30CEQTZ4xgl6UX8xYJL2FnlHawWP-N

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.

Common Table Suffixes in Oracle Apps (ALL, TL, VL, _F, _V) Explained with Examples

Table Suffixes in Oracle Apps :
 1. _ALL: A table ending with _ALL means it stores data related to multiple organizations.
 2. _TL: The table ending with _TL is a Translation Table. Such tables have a column called language.
 3. _B: Tables ending _B are the base tables.
 4. _VL: Tables ending with _VL are Views built upon multi-language or translation tables.
 5. _V  : Tables ending with _V are views.
 6. _S  : Tables ending with _S are Sequences.
 7. _A, _Avn, _ACn: Tables ending with _A, _Avn, _ACn are audit tables.
 8. _F: Tables in which data is tracked with two date columns (Effective_start_Date,                        Effective_end_date). These tables are primarily used in HRMS and payroll modules.

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.