- OracleApps Epicenter - http://www.oracleappshub.com -

Beginner’s Guide : Administering Oracle Application – Part – I

Administrating Oracle application, its important to understand the core components.In oracle application, lets take some of them start with some of the

A responsibility defines and address these:

  • These are a set of changeable options that affect the way your application runs.
  • These can be set at different level, from 11.5.10 there are 6 different level where you can make take the options.
  • Further control security by assigning a set of books to a responsibility,Application,or Site.
  • Set of books is a company or group of companies that uses Oracle Applications that share a common Chart of Accounts,Currency,and Calendar.

Profiles are established at six different levels:

  1. Site Site level profile values are used when the profile option can have only one value for the entire instance of Oracle. (example- EDI Input file path lets say if the entire server is using one directory to accept inbound files from EDI,then you would just set the profile option at the site level, then it flows down to all levels, and there is no need to set this at other levels).
  2. Application
  3. Server
  4. Organization
  5. Responsibility
  6. User

A concurrent program actually starts running based on:

In oracle application security can be classified in two broad area viz:

  • Database Security
    • Each Oracle application module database objects ( tables, views etc.,) are owned by a different Oracle ID. For example, all General Ledger objects are owned by the Oracle ID called GL, all Accounts Payables objects are owned by AP and so on.
    • All programs under a responsibility are executed using these Oracle IDs. For example, the General Ledger responsibilities use the GL database user-id.
    • Custom tables created to interface with Oracle Applications should be placed in a separate Oracle id to facilitate upgrading the application when necessary.
  • Function Security
    • Function security is the mechanism by which user access to application functionality is controlled. Function is a part of an application’s functionality that is registered under a unique name for the purpose of assigning it to, or excluding it from, a responsibility.
    • Two types of functions: Form function ( known as a form) and non-form function ( known as a sub-function).
      A form function invokes an Oracle Forms form. Forms appear in the Navigate Window and can be navigated to. Forms can exist on their own.
    • A non-form function ( sub-function) is a function executed from within a form. These are frequently associated with buttons or other graphical elements in the form. Sub-functions do not appear on the Navigate window.

AOL Integration

In AOL , Forms, Menus, Responsibilities, Profiles, Users are inter related. Here are diagram which best describe the dependency among each other.











9 Comments (Open | Close)

9 Comments To "Beginner’s Guide : Administering Oracle Application – Part – I"

#1 Pingback By Beginner’s Guide : Administering Concurrent Program – Part – II On August 19, 2007 @ 2:53 am

[…] Guide : Administering Concurrent Program – Part – IIBeginner’s Guide : Administering Oracle Application – Part – IHelpDeskKnow some of the concurrent managersApplications User Exits in ReportsBeginner jump start […]

#2 Comment By Deepak On September 6, 2007 @ 12:20 am

Excellent articles for begineers, this really make the picture clear.


#3 Comment By Ashish On March 8, 2008 @ 10:30 am

This is great article very well articulated.

reading this I have question since responsibility is tied to org-id, what would happen if you are doing external data load for GL (which is at SOB level) and say AP Invoice (which is at org-id lvl)? Can we use any of the available responsibiliteis for GL since it does not matter and for AP you have to use specific responsibility ?

#4 Comment By Charlotte On May 15, 2008 @ 9:02 am

This is very well written.
I would like to find out how to run the Menu Report as stated in the 6th bullet point of Section ‘Menus’?

#5 Comment By SUKANTA SAMAL On July 5, 2008 @ 9:49 pm

Article while going through gave me better idea to learn and its more than from my expection

#6 Pingback By Incompatibility and Request Sets « Discover Oracle Application On August 22, 2008 @ 11:50 pm

[…] Beginner’s Guide : Administering Oracle Application – Part – I […]

#7 Pingback By Incompatibility and Request Sets On August 23, 2008 @ 12:04 am

[…] Beginner’s Guide : Administering Oracle Application – Part – I […]

#8 Comment By renu On October 16, 2008 @ 2:35 am


#9 Comment By kapil raju On January 12, 2010 @ 11:55 pm

its a superb article for freshers….and give a lot of knowledge regarding AOL

thanks a lot for providing such an excellent info..