Oracle Application User Profiles

Swadhin Ray
Oracle Apps Profiles option:

A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes its responsibility by Oracle AOL (Application Object Library). The profile option can be changed by the user any time they want.

How the business needs are are fulfilled by setting Oracle Application user profile?

The user can alter the behavior of the application (altering the User Interface of the application) based on our preference that was set earlier by using the options that is provided by Oracle AOL (Oracle Application Object Library).
By changing the product-specific variables, the functionally of our application can be set as per our business rules.

Oracle application profile option can be set on four different levels as described below:
1.      Site level  
2.      Application level
3.      Responsibility level
4.      User level

These levels have been prioritized to user profile level as highest level hierarchy followed by Responsibility, Application and Site - which is considered as the lowest level. Based on the hierarchy the higher level profile option always overrides the lower level profile options. Profile options are present at each level of hierarchy.

Site Level:
This profile level is the lowest option in the hierarchy. Setting this option or setting the values will alter the application that was running earlier.

Application level:
This user profile comes just above the Site profile option and these option values affect the way a specific application runs.

Responsibility Level:
This type of user profile comes above the Application level. These option values alter the way the application runs for all the users for this particular responsibility.

User Level:
This is the final and highest level of Oracle Application Profiles. Setting this user level option changes the way of the application that runs under an application user.

How to define user's profiles:

We can refer system profiles by using FND_PROFILE.VALUE(profile_name) as system profiles  already exist in the application. We can also define the profiles which are not provided by Oracle for custom user profile. These profiles can be set by using PL/SQL or can be done through Application User Interface.

If we have a company which sells a product like mobiles and the discount % can be provided by the Sales Manager or Sales Representative, they can give the discount when a order is been placed.

Let’s assume that we have two different users Sales Manager and Sales Representative and both uses Order Management as application but with different responsibilities.
Say "Order Entry for Manager" is used by Sales Manager and "Order Entry Sales Person" is used by Sales Representative.

But now if we want to make a profile for discount we have to follow the steps below:

Step 1) Log in to Oracle application  -->¿   Navigate to Application Developer Responsibility  -->¿  Under "Menu" Click on 'Profile'.

Provide the Following Information:
Application: Order Management
User Profile Name: Discount Percent
Hierarchy Type: Security
Hierarchy Type Access Level: Check Site, Application, Responsibility and User.

Now Save it.

Step 2) Assign the profile "Discount Percent" to sales manager or sales representative, which should allow the manager to give a discount for 10% and the sales representative to give a discount for 5% on an order.

Switch responsibility to "System Administrator" --> Navigate to 'Profile' under “Menu" --> click on 'System' --> search for Profile as "Discount%Percent%" on User level and give the sales manager name.

After which the defined profile will be displayed on 'System Profile Values' Window.  Here the Profile Option Name is the User Profile Name that was defined in step number one.
Step 3) Assign a value of 10 to sales manager user and 5 for sales representative user. If we have too many managers and sales representative then the best way to assign the profile to the responsibility for each criteria like for managers responsibility and as well as representative responsibility.

Step 4) You can search for each user responsibility and check if the values that were set are getting reflected or not.

Now we can test this by setting up different values in test environment without code change.

For more information on Oracle Profile option in ERP application, please login to Oracle Technology website and have a look to the documents provided:
Swadhin Ray

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.