How to Implement User Profiles?
Implementing User Profiles :
You should define user profile options whenever you want your application to react in different ways for different users, depending on specific user attributes.
You can decide whether your end users can view and update options you define at the User level or you can also define the option such that your end users could not see or change its value.
Predefined User Profile Options :
Database Profile Options :
Oracle Application Object Library provides many user profile options that the Oracle System Administrator or the users can see and update.
Internally Generated Profile Options :
Oracle Application Object Library also provides a set of profile options that you can access via the user profile routines. You can retrieve values for these profile options in your forms and programs.
However, except for the profiles CONC_PRINT_OUTPUT and CONC_PRINT_STYLE, you cannot change their values. System administrators and end users cannot see the values for, nor change the values of, these profile options.
⦁ FND_PROFILE: User Profile APIs :
You can use the user profile routines to manipulate the option values stored in client and server user profile caches.
On the client, a single user profile cache is shared by multiple form sessions. Thus, when Form A and Form B are both running on a single client, any changes Form A makes to the client’s user profile cache affect Form B’s run–time environment, and vice-versa.
On the server, each form session has its own user profile cache. Thus, even if Form A and Form B are running on the same client, they have separate server profile caches. Server profile values changed from Form A’s session do not affect Form B’s session, and vice versa.
Similarly, profile caches on the server side for concurrent programs are separate.
Also, note that the server–side profile cache accessed by these PL/SQL routines is not synchronized with the C–code cache. If you put a value using the PL/SQL routines, it will not be readable with the C–code routines.
Any changes you make to profile option values using these routines affect only the run–time environment.
The effect of these settings ends when the program ends, because the database session (which holds the profile cache) is terminated.
⦁ FND_PROFILE.PUT :
Summary procedure FND_PROFILE.PUT
(name IN varchar2,
value IN varchar2);
Location FNDSQF library and database (stored procedure)
Description Puts a value to the specified user profile option. If the option does not exist, you can also create it with PUT.
Arguments (input)
name The (developer) name of the profile option you want to set.
Value The value to set in the specified profile option.
⦁ FND_PROFILE.GET
Summary procedure FND_PROFILE.GET
(name IN varchar2,
value OUT varchar2);
Location FNDSQF library and database (stored procedure)
Description Gets the current value of the specified user profile option, or NULL if the profile does not exist.
Arguments (input)
name The (developer) name of the profile option whose value you want to retrieve.
Arguments (output)
Value The current value of the specified user profile option as last set by PUT or as defaulted in the current user’s profile.
Example FND_PROFILE.GET (’USER_ID’, user_id);
⦁ FND_PROFILE.VALUE
Summary function FND_PROFILE.VALUE
(name IN varchar2) return varchar2;
Location FNDSQF library and database (stored function)
Description VALUE works exactly like GET, except it returns the value of the specified profile option as a function result.
Arguments (input)
Name The (developer) name of the profile option whose value you want to retrieve.
A user profile is a set of changeable options that affects the way your applications run. Oracle Application Object Library establishes a value for each option in a user’s profile when the user logs on or changes responsibility. Your user can change the value of profile options at any time. Oracle Application Object Library provides many options that your users can set to alter the user interface of your applications to satisfy their individual preferences.
Oracle Applications user profiles help you satisfy the following business needs. You should be able to:
* Set options that affect your application’s behavior to your preference
* Modify product–specific variables that affect the functionality of your application to suit your business environment
User profile options exist at Site, Application, Responsibility and User levels. Oracle Application Object Library treats user profile levels as a hierarchy, where User is the highest level of the hierarchy, followed by Responsibility, Application and at the lowest level, Site. Higher–level option values override lower–level option values. Each user profile option ordinarily exists at each level.
* Site Level is the lowest user profile level. Site–level option values affect the way all applications run at a given installation.
* Application : Application is the user profile level immediately above Site. Application–level option values affect the way a particular application runs.
* Responsibility Level :Responsibility is the user profile level immediately above Application. Responsibility–level option values affect the way applications run for all users of a responsibility.
* User Level : User is the highest user profile level and is immediately above Responsibility. User–level option values affect the way applications run for an application user.
Implementing User Profiles :
You should define user profile options whenever you want your application to react in different ways for different users, depending on specific user attributes.
You can decide whether your end users can view and update options you define at the User level or you can also define the option such that your end users could not see or change its value.
Predefined User Profile Options :
Database Profile Options :
Oracle Application Object Library provides many user profile options that the Oracle System Administrator or the users can see and update.
Internally Generated Profile Options :
Oracle Application Object Library also provides a set of profile options that you can access via the user profile routines. You can retrieve values for these profile options in your forms and programs.
However, except for the profiles CONC_PRINT_OUTPUT and CONC_PRINT_STYLE, you cannot change their values. System administrators and end users cannot see the values for, nor change the values of, these profile options.
⦁ FND_PROFILE: User Profile APIs :
You can use the user profile routines to manipulate the option values stored in client and server user profile caches.
On the client, a single user profile cache is shared by multiple form sessions. Thus, when Form A and Form B are both running on a single client, any changes Form A makes to the client’s user profile cache affect Form B’s run–time environment, and vice-versa.
On the server, each form session has its own user profile cache. Thus, even if Form A and Form B are running on the same client, they have separate server profile caches. Server profile values changed from Form A’s session do not affect Form B’s session, and vice versa.
Similarly, profile caches on the server side for concurrent programs are separate.
Also, note that the server–side profile cache accessed by these PL/SQL routines is not synchronized with the C–code cache. If you put a value using the PL/SQL routines, it will not be readable with the C–code routines.
Any changes you make to profile option values using these routines affect only the run–time environment.
The effect of these settings ends when the program ends, because the database session (which holds the profile cache) is terminated.
⦁ FND_PROFILE.PUT :
Summary procedure FND_PROFILE.PUT
(name IN varchar2,
value IN varchar2);
Location FNDSQF library and database (stored procedure)
Description Puts a value to the specified user profile option. If the option does not exist, you can also create it with PUT.
Arguments (input)
name The (developer) name of the profile option you want to set.
Value The value to set in the specified profile option.
⦁ FND_PROFILE.GET
Summary procedure FND_PROFILE.GET
(name IN varchar2,
value OUT varchar2);
Location FNDSQF library and database (stored procedure)
Description Gets the current value of the specified user profile option, or NULL if the profile does not exist.
Arguments (input)
name The (developer) name of the profile option whose value you want to retrieve.
Arguments (output)
Value The current value of the specified user profile option as last set by PUT or as defaulted in the current user’s profile.
Example FND_PROFILE.GET (’USER_ID’, user_id);
⦁ FND_PROFILE.VALUE
Summary function FND_PROFILE.VALUE
(name IN varchar2) return varchar2;
Location FNDSQF library and database (stored function)
Description VALUE works exactly like GET, except it returns the value of the specified profile option as a function result.
Arguments (input)
Name The (developer) name of the profile option whose value you want to retrieve.
A user profile is a set of changeable options that affects the way your applications run. Oracle Application Object Library establishes a value for each option in a user’s profile when the user logs on or changes responsibility. Your user can change the value of profile options at any time. Oracle Application Object Library provides many options that your users can set to alter the user interface of your applications to satisfy their individual preferences.
Oracle Applications user profiles help you satisfy the following business needs. You should be able to:
* Set options that affect your application’s behavior to your preference
* Modify product–specific variables that affect the functionality of your application to suit your business environment
User profile options exist at Site, Application, Responsibility and User levels. Oracle Application Object Library treats user profile levels as a hierarchy, where User is the highest level of the hierarchy, followed by Responsibility, Application and at the lowest level, Site. Higher–level option values override lower–level option values. Each user profile option ordinarily exists at each level.
* Site Level is the lowest user profile level. Site–level option values affect the way all applications run at a given installation.
* Application : Application is the user profile level immediately above Site. Application–level option values affect the way a particular application runs.
* Responsibility Level :Responsibility is the user profile level immediately above Application. Responsibility–level option values affect the way applications run for all users of a responsibility.
* User Level : User is the highest user profile level and is immediately above Responsibility. User–level option values affect the way applications run for an application user.
