In this post we will discuss on Oracle Apps profile options hierarchy , Oracle Apps’ behavior is regulated by Profile Option values, which decide how Oracle Apps can work. A profile option’s value can be updated at any time.
Types of Profile options available in Oracle Apps R12
There are two kinds of profile options: System and Personal profile options, which differ on who can see them and update their values.
- Only System Administrators have access to the System Profile options, which can be modified. In short, only a System Administrator can be responsible for their maintenance.
- Any Oracle Apps end user can see and change their User Profile Options.
Hierarchy of Profile options in Oracle Apps R12
Profile Options can be customized at various stages. In the hierarchy, the highest level is Site, and the lowest level is User. If two levels of a profile option are allocated, the attribute assigned at the lowest level takes priority.
- Site (limited to the whole of Apps)
- Application (limited to a single application, such as payables or receivables)
- Responsibility (limited only to a particular responsibility)
- Organization (limited to a particular organization)
- User (limited to a user)
Profile options form definitions in Oracle Apps R12
Navigation: Application Developer -> Profile
The Profiles window will appear, prompting you to fill in the following information:
Name: Give this profile alternative a meaningful and distinct name.
Application: Enter the application that would use this profile option, such as Payables or Receivables. If you need a custom program, go with the custom application.
User Profile Name: Join a new name that is both significant and distinct. In the Profile Options window, this is the name that users can see.
Description: Enter the option’s purpose or use.
Hierarchy Type Access Levels: What levels should this profile choice be available and editable.
Active dates: Enter the dates that the profile option will become active or inactive.
User Access (Visible): If your end users can see and ask this profile choice in their personal profiles, this value is true. They won’t be able to query or change values for this option if they don’t do so.
User Access (Updatable): Determines whether the end users will be able to adjust the meaning of this profile option in their Profile Values window. Otherwise, the value for this profile option must be set by your system administrator.
SQL Validation: To represent the selected rows in LOV, you can write a SQL statement. There will be no LOV if this segment is left blank; instead, the user may enter any free text as value.