Profiles option in Oracle APPS?

User Profiles are used

Ø  To set options those affect your applications behavior on your preference.

Ø  A Collection of changeable options that affect the way your applications run.

Ø  Modify Product Specific variables.

Ø  Gives Control over certain Oracle Applications features.

     

Profile Levels

Ø  Site Level

Ø  Application Level

Ø  Responsibility Level

Ø  User Level

Site Level is the lowest level.

Site: if we set the profile at site level that will be applicable all the users.

Application: If we set the profile value as application it will be applicable to the user who r having access to that specific application. If user is having both access to site and application level then application will overwrite site level.

Responsibility: If we set the profile value as responsibility that will be applicable to the users who r having access to the specific responsibility. If user having access to site, application and responsibility then responsibility will overwrite the site application.

SELECT   fu.user_name,

         frt.responsibility_name,

         furgd.start_date,

         furgd.end_date

  FROM   fnd_user fu,

         fnd_user_resp_groups_direct furgd,

         fnd_responsibility_tl frt

 WHERE       fu.user_id = furgd.user_id

         AND furgd.responsibility_id = frt.responsibility_id

         AND UPPER (fu.user_name) = 'IJ179'

         AND frt.language = 'US'

User: User is top most level. If we set profile value as user. If user having access to site application responsibility user. then user will overwrite site application responsibility.

e.g Profile named as OM: Debug Level is set at user level so it is enabled for all other levels like site, application and responsibility.

MO: Operating Unit is set at responsibility level to set the related operating unit to that responsibility.

Tables Used: FND_PROFILE_OPTIONS_TL and FND_PROFILE_OPTIIONS

Example: There is one profile named as “Responsibility Trust Level” which can set at site level and we can restrict the access of Oracle Apps to a group of users.

Default value for this is ’Normal’ and other values are ‘Administrative, External’.