Webmasters Earn Money Here!
_______________________________________
_______________________________________
Profiles
_______________________________________________
1. Overview Of Profile Options
2. Different Levels in Setting Profiles
3. Steps in Setting a Profile Option
4. Some Important Profile Options
5. Some Important API’s Of Profiles
___________________________________________________
1. Overview of User Profiles
___________________________________________________
Oracle Application user profiles help you satisfy the following business needs.
> A user profile is a collection of changeable options that affect the way your applications run.
> You can modify product – specific variables that affect the functionality of your application to suit your business environment .
> Set Options that affect your application’s behavior to your preference.
> Oracle Application establishes a value for each option in a user’s profile when the user logs on or changes responsibility
> Oracle Applications uses a set of user profile options are common to all the application products or each application product has its own unique set of user profile options.
____________________________________________________
2. Different Levels in Setting Profiles
____________________________________________________
User profile options can be set at one or more of four levels.
They are Site, Application, Responsibility, and User. Your system administrator can set default option values at any of these levels.
Site Level:
Site is the lowest profile level. Site—level option values affect the way all applications run at a given installation site.
Application Level:
Application is the profile level immediately above site. Application –level option values affect the way a given application runs.
Responsibility Level:
Responsibility is the profile level immediately above Application. Responsibility—level option values affect the way application run for all users of a given responsibility.
User Level:
User is the highest profile level and is immediately above Responsibility. User—level option values affect the way applications run for a given application user.
User Profile Hierarchy
Oracle Application 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.
____________________________________________________
3. Steps in Setting a Profile Options
____________________________________________________
> Your system administration can set values for user profile options at each profile level.
> Typically, your system administrator sets site—level option values after installing Oracle Application at a site.
> These site—level option values apply until you or your system administrator changes them.
> Oracle application derives a run—time value for each user’s profile option based on the values set at the highest hierarchy level.
> Any change your system administrator makes to your profile options takes effect as soon as you log on again or change responsibilities.
> You can set your own preference at the user—level, since your user—level setting overrides the Responsibility—level setting.
> Some option values can only be changed by the system administrator.
Steps in Setting a Profile Option
Step-1 Log into sysadmin and open the profile setup screen
Navigation: – Sysadministrator > Profile > System
Step-2 Select Profile Level
Step-3 Select Profile Name Click on Find
Step-4 Setup your Profile value at any level.
____________________________________________________
4. Some Important Profile Options
____________________________________________________
# Attachment File upload directory : This Provides the Directory path used to upload attachment files.
# Set of Books name : Provides access to specific Set of Books in GL.
# MO Operating Unit : This allows user to specify operating unit.
# Sign-on Notification : Message about failed concurrent programs of failed logins.
# Viewer : To set up Browser for viewing the documents.
# Defaulter Country : This is the default source for the Country filed for all address zones and is used by the Flexible Address Formats feature, the Flexible bank structures feature and the Tax Registration Number and Taxpayer ID Validation routines.
# Flex fields : Open Descr Window : You can control whether a descriptive flex fields window automatically opens when you navigate to a customized descriptive flex field.
_____________________________________________________
5. Some Important API’s Of Profiles
_____________________________________________________
User profile APIs can be used in your PL/SQL procedures to manipulate the option values stored in profile caches.
Procedure FND_PROFILE.PUT
(name IN varchar2, value IN varchar2);
Puts a value to the specified user profile option. If the option does not exist, you can also create it with PUT.
EX– FND_PROFILE.PUT ( ‘USER_ID’, User_Id);
procedure FND_PROFILE.GET
(name IN varchar2, value OUT varchar2);
Gets the current value of the specified user profile option, or NULL if the profile does not exist.
EX– FND_PROFILE.GET ( ‘USER_ID’, User_Id);
function FND_PROFILE.VALUE
(name IN varchar2) return varchar2;
VALUE works exactly like GET, except it returns the value of the specified profile option as a function result.
EX– FND_PROFILE.VALUE ( ‘USER_ID’);
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
_______________________________________________
1. Overview Of Profile Options
2. Different Levels in Setting Profiles
3. Steps in Setting a Profile Option
4. Some Important Profile Options
5. Some Important API’s Of Profiles
___________________________________________________
1. Overview of User Profiles
___________________________________________________
Oracle Application user profiles help you satisfy the following business needs.
> A user profile is a collection of changeable options that affect the way your applications run.
> You can modify product – specific variables that affect the functionality of your application to suit your business environment .
> Set Options that affect your application’s behavior to your preference.
> Oracle Application establishes a value for each option in a user’s profile when the user logs on or changes responsibility
> Oracle Applications uses a set of user profile options are common to all the application products or each application product has its own unique set of user profile options.
____________________________________________________
2. Different Levels in Setting Profiles
____________________________________________________
User profile options can be set at one or more of four levels.
They are Site, Application, Responsibility, and User. Your system administrator can set default option values at any of these levels.
Site Level:
Site is the lowest profile level. Site—level option values affect the way all applications run at a given installation site.
Application Level:
Application is the profile level immediately above site. Application –level option values affect the way a given application runs.
Responsibility Level:
Responsibility is the profile level immediately above Application. Responsibility—level option values affect the way application run for all users of a given responsibility.
User Level:
User is the highest profile level and is immediately above Responsibility. User—level option values affect the way applications run for a given application user.
User Profile Hierarchy
Oracle Application 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.
____________________________________________________
3. Steps in Setting a Profile Options
____________________________________________________
> Your system administration can set values for user profile options at each profile level.
> Typically, your system administrator sets site—level option values after installing Oracle Application at a site.
> These site—level option values apply until you or your system administrator changes them.
> Oracle application derives a run—time value for each user’s profile option based on the values set at the highest hierarchy level.
> Any change your system administrator makes to your profile options takes effect as soon as you log on again or change responsibilities.
> You can set your own preference at the user—level, since your user—level setting overrides the Responsibility—level setting.
> Some option values can only be changed by the system administrator.
Steps in Setting a Profile Option
Step-1 Log into sysadmin and open the profile setup screen
Navigation: – Sysadministrator > Profile > System
Step-2 Select Profile Level
Step-3 Select Profile Name Click on Find
Step-4 Setup your Profile value at any level.
____________________________________________________
4. Some Important Profile Options
____________________________________________________
# Attachment File upload directory : This Provides the Directory path used to upload attachment files.
# Set of Books name : Provides access to specific Set of Books in GL.
# MO Operating Unit : This allows user to specify operating unit.
# Sign-on Notification : Message about failed concurrent programs of failed logins.
# Viewer : To set up Browser for viewing the documents.
# Defaulter Country : This is the default source for the Country filed for all address zones and is used by the Flexible Address Formats feature, the Flexible bank structures feature and the Tax Registration Number and Taxpayer ID Validation routines.
# Flex fields : Open Descr Window : You can control whether a descriptive flex fields window automatically opens when you navigate to a customized descriptive flex field.
_____________________________________________________
5. Some Important API’s Of Profiles
_____________________________________________________
User profile APIs can be used in your PL/SQL procedures to manipulate the option values stored in profile caches.
Procedure FND_PROFILE.PUT
(name IN varchar2, value IN varchar2);
Puts a value to the specified user profile option. If the option does not exist, you can also create it with PUT.
EX– FND_PROFILE.PUT ( ‘USER_ID’, User_Id);
procedure FND_PROFILE.GET
(name IN varchar2, value OUT varchar2);
Gets the current value of the specified user profile option, or NULL if the profile does not exist.
EX– FND_PROFILE.GET ( ‘USER_ID’, User_Id);
function FND_PROFILE.VALUE
(name IN varchar2) return varchar2;
VALUE works exactly like GET, except it returns the value of the specified profile option as a function result.
EX– FND_PROFILE.VALUE ( ‘USER_ID’);
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
Webmasters Earn Money Here!
No comments:
Post a Comment