Hierarchy Profile Options
Written by Anil Passi   
Wednesday, 29 November 2006
This article is an attempt to explain the Hierarchy Profile Options with examples.


Can all the profile options be set at Organization Level and Server level?
You need to set “Hierarchy Type” field in Profile Option definition to enable that profile to be eligible for Hierarchy Level. This functionality was introduced in 11.5.9


How to find from SQL*Plus whether a Profile Option is Hierarchy Enabled?

SELECT HIERARCHY_TYPE  FROM fnd_profile_options_vl where profile_option_name = 'profile option short name' ;
If the above SQL returns SERVER, then the profile is enabled at Server Level.
If the above SQL returns ORG, then the profile is enabled for Organization Level.
If the above SQL returns SERVRESP, then the profile is enabled for both Server and Responsibility Level.


Why the need of Organization Level profile option?
For example multiple responsibilities can be attached to same Operating Unit. In such event, it can get tedious to attach the same profile option to each such responsibility.
By attaching an Organization Level Profile Option to an Operating Unit implies that all such responsibilities inherit Org Level Profile value.

Will Organization Level Profile override the Responsibility Level Profile?
Yes


Give me some example usages of Server Level Profiles
Managing Timezones
In a single Global DB Instance implementation, you may desire to display different time in UI screen, depending upon the local timezone. If you have a separate Middle Tier Server for each timezone, then timezone profile options [Enable Timezone Conversions, Client Timezone, Server Timezone] can be set at Server Level.

External WWW Facing Mid Tiers
It is possible that for security reasons, you may desire to change the functionality of Application when its accessed from External WWW facing mid-tier. Such security profiles can be assigned at server level.
For example, profile option “Node Trust Level” can be set to a value of external against a server to flag the specific mid-tier server as External. See Link for details.


Give me some example usages of Organization Level Profiles
Managing Timezones
In a single Global DB Instance implementation, you may desire to display different time in UI screen, depending upon the local timezone. If you can’t afford to have a separate Middle Tier Server for each timezone, then timezone profile options [Enable Timezone Conversions, Client Timezone, Server Timezone] can be set at Organization Level, as each Organization assumingly will be in a specific timezone.

Setting Org Level Profile Option in HRMS
A HRMS Business Group can be assigned to various Oracle HRMS Responsibilities. Keeping a track of profiles against all such responsibilities, which belong to a specific Business Group can be tedious. Hence you may simplify this by simply assigning the profile to Business Group Organisation.

What is the order of precedence for Profiles?
Security Profiles: Site Level >> Application Level >> Resp Level >> User Level
Server Profiles: Site Level >> Server Level >> User Level
Organization Profiles : Site Level >> Organization Level >> User Level



Comments (9)add
...
written by YJ , December 04, 2006
Thing that has compelled me to become regular on your portal is about the promptness in answering.Really one should appriciate the level of interest taken by you to answer each and every query out of the busy schedule.Thanks and all the best.
...
written by YJ , December 04, 2006
Thing that has compelled me to become regular on your portal is about the promptness in answering.Really one should appriciate the level of interest taken by you to answer each and every query out of the busy schedule.Thanks and all the best.
...
written by Rohit , January 30, 2007
Hello
Iam rohit
Iam new learner to Oracle Apps I Need Some Profile options Material. Could Any One Send
Thanking You
rohit_087@yahoo.co.in
...
written by FG , March 09, 2007
Hi Anil,

Please do you have any notes on the steps required for the implementation of Oracle HRMS.

Thanks

FG
...
written by Anil Passi , March 12, 2007
Hi FG

Have a look at http://oracle.anilpassi.com/hr...br100.html

thanks
anil
...
written by smruthi , May 26, 2007
Really appreciate you for knowledge sharing.Its really helpful.

I would like to know from the form where we assign a responsibility to an OU.
Please give me the answer for this.
...
written by Anil Passi , May 27, 2007
Hi Smruthi

Your answer is in link http://getappstraining.blogspo...-apps.html

To attach an OU to responsibility, navigate to SYS Administrator, and click on menu profile.

Select the responsibility, and in Profile name, select MO%Operatin%Unit

This is where the relation is defined

thanks
anil
...
written by Santosh Kumar , September 20, 2007
Hi Anil,

I am Santosh.

I am new learner to Oracle Apps I Need Some Profile options Material. Could Any One Send
any materials.

Thanks,
Santosh.

Workflow
written by Rinku , February 24, 2008
Dear Anil I am working in Oracle Purachsing Module(11.5.7) I have been facing an acute problem that When I attach a new employee in Existing Hierarchy(Position) some time it does send Notification to Approver and in few case the Requester does not get Po Approved Notification in its notification Window after Approval although it exists in Wf_Notification table Please help.........
You must be logged in to a comment. Please register if you do not have an account yet.

busy