Application Object Library
(AOL)
AOL by Vinothkumar M 1
Why AOL?
• Collection of pre-built application components &
facilities.
• Contains shared components - database objects,
forms, reports, libraries. Coding standards use AOL.
Roles of AOL
• AOL links all objects of Oracle application.
• It stores and contains information and details about the
data in file system.
• It is the backbone of oracle apps, which integrates all
the objects and derives a relation between them.
AOL by Vinothkumar M 2
Agenda of AOL
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle
OracleSchema
Schema Executable Forms Forms
AOL by Vinothkumar M 3
FND
Applications
Navigation Application → Register
AOL by Vinothkumar M 4
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle Schema Executable Forms
AOL by Vinothkumar M 5
Below you can see the screen shot of oracle Purchasing Application
definition.
AOL by Vinothkumar M 6
Oracle
UserName
Table FND_ORACLE_USERID
: ~ ORACLE_ID
Navigation Security → Oracle →
Register
AOL by Vinothkumar M
15
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle
OracleSchema
Schema Executable Forms Forms
AOL by Vinothkumar M 8
Default Oracle User-Names in oracle
apps
AOL by Vinothkumar M 9
Data
Group
Table: FND_DATA_GROUPS
~ DATA_GROUP_ID
Navigation Security → Oracle → DataGroup
AOL by Vinothkumar M 10
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle Schema Executable Forms
AOL by Vinothkumar M 11
Menus
Tabl FND_MENUS
e: ~ MENU_ID Navigation: Application >
Menu
AOL by Vinothkumar M 2
3
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle Schema Executable Forms
AOL by Vinothkumar M 13
Menus:
• A menu is a hierarchical arrangement of
functions and submenus with functions.
Each responsibility has a menu assigned
to it.
• A Responsibility becomes "Full Access",
when it includes all the per-defined
functions in application that are included in
the menu attached.
• A sub menu should be defined first (Lowest
level sub-menu) and attached to main menu.
AOL by Vinothkumar M 14
Purchasing Module
AOL by Vinothkumar M 15
To view the hierarchical structure click "View
Tree"
AOL by Vinothkumar M 16
Web
Based
Functions
Form
Function
s
AOL by Vinothkumar M 17
Level 1
Level 2
AOL by Vinothkumar M 18
Level 3
AOL by Vinothkumar M
40
Form
Functions
Table FND_FORM_FUNCTIONS
: ~ FUNCTION_ID
FND_FORM_FUNCTIONS_TL
~ FUNCTION_ID
~ LANGUAGE
FND_FORM
~ APPLICATION_ID
~ FORM_ID
FND_FORM_TL
~ APPLICATION_ID
~ FORM_ID
~ LANGUAGE
Navigation: Application >
Function
AOL by Vinothkumar M 20
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle
OracleSchema
Schema Executable Forms
AOL by Vinothkumar M 21
Purchase Order (Form
Based)
Sub Menu: Purchase Orders: Subfunctions
AOL by Vinothkumar M 22
Now we have identified the form function "Purchase
Orders"
What is a Function?
- A function is part of an application's functionality that is registered under
a unique name for the purpose of assigning it to a responsibility , or
excluding it from responsibility.
Types of Functions
~ form functions
~ non-form functions
AOL by Vinothkumar M 23
FORM Blocks::
DESCRIPTION-
Function :
Users do not see this unique function name. The
function name can be used to call the function
programmatically.
User Function Name :
Enter a unique name that describes the function. This name is
used when assigning functions to menus.
AOL by Vinothkumar M 24
PROPERTIES-
Typ :
e Type is a free-form description of the function's use (function type will
be validated in a future version of this form). A function's type is passed
back when a developer tests the availability of a function. The
developer can write code that takes an action based on the function's
type.
Maintenance Mode Support:
Reserve for Future.
Context Dependence :
Some functions are controlled by profile options, that affect what
the user can perform within the current context. context
dependence are Responsibility, Organization, Security Group, None.
AOL by Vinothkumar M 25
Form
-
Form /Application :
If you are defining a form function, select the name and
application of your form.
Parameters :
Enter the parameters you wish to pass to your function. Separate
parameters with a space.
For a form function, if you specify the parameter
QUERY_ONLY=YES, the form opens in query-only mode. Oracle
Application Object Library removes this parameter from the list
of form parameters before opening the form in query-only mode.
AOL by Vinothkumar M 26
Non Form Based Function: Sub
Function
AOL by Vinothkumar M 27
Responsibility
Table FND_RESPONSIBILITY
: ~ Application_ID
~ Responsibility_ID
FND_RESPONSIBILITY_TL
~ Application_ID
~ Responsibility_ID
~ Language
AOL by Vinothkumar M 28
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle
OracleSchema
Schema Executable Forms Forms
AOL by Vinothkumar M 29
Why?
- It determines user
- access Oracle application or Self service web application
- which function, reports, concurrent program user can run.
About-
- Application Name and Responsibility name uniquily identifies the
responsibility.
- Responsibility Key: unique name for a responsibility that is used by
loader programs.
- A responsibility can be associated with only one Application.
Mandatory Fields:
- Effective Date From
- Data Group
- Name
- Application
- Menu
AOL by Vinothkumar M 30
Oracle Application Responsibility:
AOL by Vinothkumar M 31
Web
Application
AOL by Vinothkumar M 32
Users
Tabl FND_USER
e: ~ USER_ID
AOL by Vinothkumar M 33
FND user
Responsibility
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle
OracleSchema
Schema Executable Forms Forms
AOL by Vinothkumar M 34
AOL by Vinothkumar M 35
Request Security Group (Or) Request
Group
Tabl FND_REQUEST_GROUPS Navigation: Security > Responsibility >
e: ~ APPLICATION_ID Request
~ REQUEST_GROUP_ID
AOL by Vinothkumar M 36
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle Schema Executable Forms
AOL by Vinothkumar M 37
SUMMARY::
Request Security -
Used to specify reports, request sets & Concurrent programs
Request Security Group -
When a request group is assigned to a responsibility, the request
group is referred to as a request security group.
AOL by Vinothkumar M 38
Executable
Tabl FND_EXECUTABLES
e: ~ APPLICATION_ID
~ EXECUTABLE_ID
AOL by Vinothkumar M 39
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle
OracleSchema
Schema Executable Forms Forms
AOL by Vinothkumar M 40
Why?
To Map executable source file with concurrent programs.
Source File <---> Concurrent Program
How executable is Identified?
Application Name + Program Name = Executable
Execution Method-
The execution method cannot be changed once the
concurrent program executable has been assigned to one
or more concurrent programs in the Concurrent Programs
window.
AOL by Vinothkumar M 41
The possible execution methods are:
Host The execution file is a host script.
Oracle Reports The execution file is an Oracle Reports file.
PL/SQL Stored The execution file is a PL/SQL stored
Procedure Java Stored procedure. The execution file is a Java
Procedure Java stored procedure.
Concurrent Program The execution file is a program written in
Multi Language Java.
SQL*Loade
Function The execution file is a function (MLS function) that
r SQL*Plus supports running concurrent programs in multiple
Spawned languages.
Immediate The execution file is a SQL script.
The execution file is a SQL*Plus
script. The execution file is a C or
Pro*C program.
The execution file is a program written to run as a
Request Set Stage subroutine of the concurrent manager. We
Function recommend
against defining new immediate concurrent
programs, and suggest you use either a PL/SQL
Stored Procedure or a
Spawned C Program instead.
PL/SQL Stored Function that can be used to
calculate the completion statuses of request set
stages.
AOL by Vinothkumar M 42
Lets Consider a sample Oracle Report
Executable
Location:
AOL by Vinothkumar M 43
Concurrent Program
Table: FND_CONCURRENT_PROGRAMS_TL
FND_CONCURRENT_PROGRAMS ~APPLICATION_ID
~APPLICATION_ID ~CONCURRENT_PROGRAM_ID
~CONCURRENT_PRO ~LANGUAGE
GRAM_ID
AOL by Vinothkumar M 75
FND user
Responsibility
Data Group Request Group Menu
Application Concurrent Prog. Form & Sub functions
Oracle
OracleSchema
Schema Executable Forms Forms
AOL by Vinothkumar M 45
Concurrent Program Parameters:
AOL by Vinothkumar M 46
Monitoring Requests
Navigation: System Administrator →
Requests
AOL by Vinothkumar M
89
Submitting a Requests:
AOL by Vinothkumar M 48
Two Types of Requests:
■
Single
■
Request
Request
Single Set
Request
If we want to execute a single concurrent program, we need to
select type as Single request.
Request Set
If we want to execute multiple concurrent program one by one in
a sequence order, we need to create a Request set and submit it
using this type.
It is possible we can pass one concurrent programs output as
input to another concurrent program.
Single Request
Request Set
SEQ
10
20
30
AOL by Vinothkumar M 49
Request Sets:
Execution of multiple concurrent program one by one or in parallel, with
passing one program output as input to other program in sequence or
executing in a sequence order.
How to create Request set?
Step 1 Step 1 Step 1
Stage 1 Stage 2 Stage 3
Step 2 Step 2
Create Request Set using 2 methods
Steps to create Request set
Step 1: Creating Stages (1) Request Set Wizard
Step 2: Linking Stages
(2) Manual Creation
AOL by Vinothkumar M 50
Stage Organization:
Requests can be organized in two ways,
(1) Parallel Execution
(2) One by one [Sequence] Execution
Parallel Execution:
When we want to run all the requests simultaneously (or) in Parallel within a
stage parallel execution method is used.
Note** This should be used only,
- If the requests within a stage doesn't have any dependency with other like
one request executing based on output of another etc.
Stage 1
Request 1
Request 2
Request 3
Request 4
AOL by Vinothkumar M 51
One by one [Sequence] Execution
When we want to run requests one by one in a sequence order, this
execution method is used.
Stage 1 Stage 2 Stage
3
Request 3
Request 1 Request 2
Request 4
Note**
Not only Requests executes in order even stages executes in order.
Unless stage1 is completed stage 2 & stage 3 will not be executed.
A stage is not complete when all the requests within the stage are
completed.
AOL by Vinothkumar M 52
Stage Statuses:
A stage can be completed wit the following statuses.
(a) Success
(b) Warning
(c) Error
Linking Stages:
Based on the above statuses we can link stages (or) setup sequence of
execution of stages.
Stage 3
Error
Request 2
Stage 1
Success
Request 1 Request 5
Request 3 Stage 4
Warning Request 4
AOL by Vinothkumar M 97
Stage 2
Creating Request Set:
Navigation: System Administrator → Concurrent →
Set
Method 1: Using Request Set
Wizard. Method 2: Manual Creation.
AOL by Vinothkumar M
98
Method 1: Using Request set Wizard
Step 1: Click “Request Set Wizard
Button”
Step 2: Select execution option for requests to be executed. In this
case I'm selecting Sequential order.
AOL by Vinothkumar M 55
Step 3: Select a “Decision” when the request sets ends with status
ERROR. .
Step 4: Enter the details of the request
set.. .
AOL by Vinothkumar M 56
Step 5: Select option when “Output” should be generated for the
request.
Step 6: Lists the concurrent programs in a sequence order of execution. Any
concurrent program of any application can be included.
AOL by Vinothkumar M 57
Step 7: After clicking finish button, the following note will be displayed
to the user.
Step 8: Request Set Created
Successfully.
AOL by Vinothkumar M 58
Step 8: View the default stage details. Click “Define stages” button.
Since we have define the request set using wizard, by default all the
request will be created in single stage.
AOL by Vinothkumar M 59
Step 9: To view how stages are linked click “Link Stages” button.
By Default, when the Stage statuses in “WARNING” or “SUCCESS”,
the option “Stage to Proceed to On” will be defaulted to same
program name.
AOL by Vinothkumar M 60
Method 2: Manually Creating Request set
Considering the same programs in method 1. This time we are going to
define separate stage for each programs.
Stage 1 Stage 2 Stage 3
Stage 1: Buyer Listing.
Stage 2: Buyer's Requisition Action
Reminder.
Stage 3: Item Detail's Listing.
AOL by Vinothkumar M 61
Step 1: Enter Request Set
Details.
AOL by Vinothkumar M 62
Step 2: Define
Stages
AOL by Vinothkumar M 63
Step 3: Assigning Request/Concurrent Program for the Request in
a stage. Click “Requests” button.
AOL by Vinothkumar M 64
Step 4: Similarly repeat steps 2 to Step 3 to Define all Stages and associate
programs for each request.
Stage 2
Stage 3
AOL by Vinothkumar M 65
Step 5: Link Stages by clicking “Link Stages”
button.
If Stage 1 is success, it will execute
stage 2. If stage 2 is success, it will
execute stage 3.
AOL by Vinothkumar M 66
Step 6: Assign Request set to a Request
Group.
AOL by Vinothkumar M 67
Profile Options:
What is User Profile option ?
A Profile option is set of values/options, which is used to
direct the functioning of Oracle application.
Why Profile Option?
- To control & manage transactions and activities in oracle
application.
- To make the Oracle application flexible in the way it
functions.
- Provides option to define custom rules for users.
AOL by Vinothkumar M 68
Navigation: (Create User
Profile) Application
Developer → Profile
AOL by Vinothkumar M 69
Profile Types:
• System Profile (Oracle Seeded Profile Options)
• User Profile (Custom Profile created by user)
Profile Levels:
• Site Level
• Application Level
• Organization Level
• Responsibility Level User Level
Profile Hierarchy:
(High) User --> Responsibility --> Organization --> Application --> Site
(Low)
Level Level ID
Site 10001
Application 10002
Responsibility 10003
User 10004
Server 10005
Oracle R12 - AOL by Kumar S 70
Organization 10006
Dinesh
Value Sets
Reference: Oracle Flexfield Guide
AOL by Vinothkumar M 71
Valueset usage:
Valueset can be associated with below Application objects,
• KFF (Key flex fields)
•
• DFF (Descriptive flex fields)
•
•
• Concurrent Program Parameters
AOL by Vinothkumar M 72
Step 3: Choosing a Validation Type
There are 6 validation types available for Valueset,
1. None (not validated at all)
2. Independent
3. Dependent
4. Table
5. Special (advanced)
6. Pair (advanced)
AOL by Vinothkumar M 73
AOL by Vinothkumar M 74
Independent:
It provides a predefined list of values for a segment.
•
These values can have an associated description.
•
The meaning of a value in this value set does not depend on the value of any other
segment.
•
Independent values are stored in an Oracle AOL table.
AOL by Vinothkumar M 75
AOL by Vinothkumar M 76
Table:
It provides a predefined list of values like an independent set, but its
values are stored in an application table.
use a table-validated set when you have a table whose values are
already maintained in an application table.
Table validation also provides some advanced features such as
allowing a segment to depend upon multiple prior segments in
the same structure.
AOL by Vinothkumar M 77
AOL by Vinothkumar M 78
Edit Information:
AOL by Vinothkumar M 79
Dependent:
•
• A dependent value set is similar to an independent value set, except that the
available values in the list and the meaning of a given value depend on which
• independent value was selected in a prior segment of the flexfield structure.
• You must define your independent value set before you define the dependent
value set that depends on it.
AOL by Vinothkumar M 80
Edit Information:
AOL by Vinothkumar M 81
Flexfield
A flexfield is a field made up of sub–fields, or segments. A
flexfield appears on your form as a pop–up window that
contains a prompt for each segment. Each segment has a
name and a set of valid values.
There are two types of flexfields:
(1)key flexfield
(2)Descriptive flexfield
AOL by Vinothkumar M 82
Navigation: SYS ADMIN RESP → Application → Flexfield → Key →
Segments
AOL by Vinothkumar M 83
Flexfield segments
Note** in all the base tables you can see Segment Columns where the flexfield value
will be stored.
AOL by Vinothkumar M 84
Descriptive Flexfield
Descriptive flexfields provide customizable "expansion space" on your
forms. You can use descriptive flexfields to track additional information,
important and unique to your business, that would not otherwise be
captured by the form.
DFF has 2 different types of segments,
●
Global segment is a segment that always appears in the
descriptive flexfield pop–up window.
●
Context–sensitive segment is a segment that may or may not
appear depending upon what other information is present in
your form.
AOL by Vinothkumar M
Enabling DFF in a Purchase Order form:
DFF
AOL by Vinothkumar M 86
Step 1: Know the details of the DFF
Navigation: Help Menu → Diagnostics → Examine
1 Input Apps Username
Password
Give the Block & field
values as given
3
AOL by Vinothkumar M 87
Step 2: Enable the DFF
Navigation: SYS ADMIN → Application → Flexfield → Descriptive → Segments
Unfreeze the flexfield
definition to enable
segment.
AOL by Vinothkumar M 88
Step 3: Enter the segment information as below
Now save the
changes.
AOL by Vinothkumar M 89
Click OK
Note** if you want any validation to be enabled, assign a value set else
leave it blank as it is optional.
AOL by Vinothkumar M 90
Step 4: Now freeze the flexfied after the changes.
AOL by Vinothkumar M 91
Flexfield successfully compiled
AOL by Vinothkumar M 92
Lets Query Purchase Order form
DFF Enabled
DFF Enabled
AOL by Vinothkumar M 93
AOL by Vinothkumar M 94
