Miscellaneous Technology

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

Anil Passi

Comments   

0 #1 YJ 2006-12-04 00:00

Thing that has compelled me to become regular on your portal is about the promptness in answering.Reall y 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.

Quote

0 #2 YJ 2006-12-04 00:00

Thing that has compelled me to become regular on your portal is about the promptness in answering.Reall y 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.

Quote

0 #3 Rohit 2007-01-30 00:00

Hello
Iam rohit
Iam new learner to Oracle Apps I Need Some Profile options Material. Could Any One Send
Thanking You
rohit_087yahoo.co.in

Quote

0 #4 FG 2007-03-09 00:00

Hi Anil,

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

Thanks

FG

Quote

0 #5 Anil Passi 2007-03-12 00:00

Hi FG

Have a look at http://www.google.com/search?q=site:apps2fusion.com+hrms-setups-not-br100

thanks
ani l

Quote

0 #6 smruthi 2007-05-26 00:00

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.

Quote

0 #7 Anil Passi 2007-05-27 00:00

Hi Smruthi

Your answer is in link http://getappstraining.blogspot.com/2006/10/orgid-and-multi-org-in-oracle-apps.html

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

Sel ect the responsibility, and in Profile name, select MO%Operatin%Uni t

This is where the relation is defined

than ks
anil

Quote

0 #8 Santosh Kumar 2007-09-20 05:38

Hi Anil,

I am Santosh.

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

Tha nks,
Santosh.

Quote

0 #9 Abhijit A 2008-02-24 15:03

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(Posit ion) 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.........

Quote

0 #10 jyothsna.A 2008-09-11 13:59

hi,
can we get function_id fron fnd_profile

Quote

0 #11 Valeria 2008-10-31 15:53

Hello Anil,
Do you know of a way to limited user to update only profile option name "Printer". I gave them the personal profile option but want to limit
and allow only the Printer profile option.
Thank you

Quote

Refresh comments list
RSS feed for comments to this post

Add comment