f Get Oracle Apps Traning Here: Profile Options Examples Screenshots

This work is licensed under a Creative Commons -NonCommercial 2.5 License.



Wednesday, October 11, 2006

Profile Options Examples Screenshots

You have reached this page from Profile Options Training Article

Firstly, lets define the responsibility for Clerk, as we discussed in Article.

Next, lets define the sales manager responsibility, as we discussed in Article.


Lets define user JOHN, that is Clerk



And also, lets define user SMITH ( Sales manager )

Now, we need to define the profile option for discount, hence go to responsibility "Application Developer"

When you click on menu "Profile" above, you will then see below screen for defining profile option. Please note that the "Name" field is the short name of profile option, and it is this name used in API call to FND_PROFILE.value


Now, after having defined a profile option, its time to assign these to JOHN & SMITH.
Hence go to responsibility "System Administrator"



Click on Menu Profile/System, as below

The profile option assignment screen looks like below. Enter JOHN in USER, OEPASSI% in Profile, to select profile named "OEPASSI Maximum Discount Allowed"

Assign a value of 5 to the user.


Click on torch, to return to search screen as below


and this time we will assign value of 15 against user SMITH.

OK, what if we have too many clerks, we can also simply assign profile value to Responsibility of Clerk. Doing so, all the users that use this responsibility, will inherit profile option value against Responsibility.




Assign 5% max discount for Clerks

Now, lets select Sales Manager responsibility in profile screen

Search on this...as below......

Assign value 15% to Sales Manager responsibility.



That's it for setup.
Any questions? leave your question by click on link Leave Comment for this article

Thanks
Anil Passi

Comments on "Profile Options Examples Screenshots"

 

Anonymous Anonymous said ... (7:12 AM) : 

u really make things so easy to understand....

thanks a ton!

regards,
viplendra

 

Anonymous Anonymous said ... (12:43 PM) : 

Just WOW . Spend ann hour today looking at your postings . You are GREAT. Thanks for sharing

Artur bakhtriger

 

Anonymous Anonymous said ... (12:45 PM) : 

Spend about 2 hrs today looking at your postings. They are so informative . Thank you so much for doing this great job

Artur Bakhtriger

 

Anonymous SANDY said ... (9:55 PM) : 

THANKS A TON!

SANDY

 

Anonymous Anonymous said ... (6:13 AM) : 

HI

Could you le me know which version of Apps do these screen shots belong?

Ritz

 

Blogger Anil Passi said ... (6:22 AM) : 

Hi Ritz

this is from 11.5.10

thanks
anil

 

Blogger Muskan said ... (1:43 AM) : 

Hi Anil,

I am spending lot of time on this site you have made things so clear its very easy to understand.

thanks
Muskan

 

Blogger Anil Passi said ... (1:51 AM) : 

Hi Muskan

Good to hear that this site is helping you.

Thanks,
Anil

 

Anonymous Anonymous said ... (12:19 AM) : 

Thats nice.
"Profile options" well described.
Thanks a ton :)

 

Blogger Shakir said ... (12:52 PM) : 

Thanks a lot, I was about to search on metalink when I decided to google it and I found here how to create a custom profile option and use it.

Shakir.

 

Blogger jitin said ... (3:56 AM) : 

hi ANIL u site is simply gr8....i have a doubt ,when i give fnd_profile.value to a profile which has value at user level it is not returning anything but if i give a site level value it is returning that......i need to return the value at user level...plz help.......JITIN

 

Blogger muni said ... (8:48 AM) : 

Amazingly explained!!!!
But i have one doubt, when ever we access profile values using the code fnd_profile(),from where does the code related to the function gets executed? will the API's reside in any of the library files?

 

Blogger Anil Passi said ... (12:30 PM) : 

hi mani

fnd_profile that I was refering to is a plsql package. the api looks at a table named fnd_profile_option_values to return the profile value for the current login session.

as soon as you login, global variables in a package named fnd_global are set to reflect your user_id, responsibility_id etc.

fnd_profile.value uses a combination of above info to return a value.

PS: Fnd_profile api does caching too, for efficiency purpooses.

thanks
anil

 

Blogger Shilpa said ... (10:15 PM) : 

Finally this time i understood the profile options concept.. after reading many docs..

Thanks a lot..
its really helping too much

 

Anonymous Anonymous said ... (5:52 AM) : 

Hi Anil,

A wonderful site I must say, even after working for more then a year in Apps I was not confident enough, your site helped me a lot.

Regards,
Nitin Guru

 

Anonymous Anonymous said ... (8:46 AM) : 

Hi Anil ,

Thanks a lot for making such a wonderful blog on Oracle applications.

Regards
Ankit

 

Blogger salman said ... (7:13 AM) : 

Hi! Anil

I have recently started studing oracle apps. n material here in this blog is quite interesting n helpful.......
so plz keep doing social service

Salman

 

Blogger JV said ... (2:57 AM) : 

Hi Anil,

A wonderful site I must say, i got more valuable information from these docs ... i never forget ur help.
Keep up the good work.

Regards,
Lakshmi Narayana Jillellamudi

 

Blogger madhavi said ... (11:00 PM) : 

Hi anil,

Im a beginner in oracle apps technical consultant. I found ur site very helpful. Can u suggest the ways i know the GL module

 

Blogger madhavi said ... (11:07 PM) : 

Hi im a beginner i found your site very useful. Suggest some steps to learn customising forms from template.fmb

Regards
madhu

 

Anonymous Bharat Bhushan said ... (10:35 PM) : 

Hi Anil,


I have no words to appriciate u.what a good job u r doing.


Bharat

 

Anonymous Anonymous said ... (11:31 PM) : 

Hi Anil,

Explained profile options setup very well. Its easy to understand and very useful. Thanks.

regards
J.Siva Kumar

 

Anonymous Anonymous said ... (11:09 PM) : 

Hi Anil,

Great Job ! Thanks a ton !

Regards,

Nisarg

 

Anonymous Anonymous said ... (1:55 PM) : 

Hi Anil,
Thanks a lot for posting wonderful articles like this.I was using these features but was not too much confident.
Can you please give some example of profiles setting at server,site and application level.
I think that printer configuration etc can be done at site level.
Keep up the good work.
Rgds,
Debashis

 

Anonymous Anonymous said ... (2:33 AM) : 

Hi Anil,

I am beginner for Oracle Apps. Thanks alot for your valuable information.

 

Anonymous Anonymous said ... (12:34 PM) : 

Amazing article...Its so simple to understand...Terrific job Anil....

 

Anonymous Anonymous said ... (6:06 AM) : 

Hi Anil:

Thanks a lot for spending time in helping others, your help is greatly appreciated!! Can you help us in working on about BPEL process and for what it is used in real-time!! Thanks again!!!

Radhika Menon

 

Blogger Anil Passi said ... (8:21 AM) : 

Hi Radhika

BPEL will replace Oracle Workflows in Fusion. It is on my agenda to write about BPEL too.

Thanks,
Anil

 

Blogger DK Pandey said ... (6:49 AM) : 

hi Anil,
We are implementing ORACLE EBS in Cairo EGYPT that has PO INV GL AP FA....I am working as System Analyst and the Modules will be live in few days.
One Q ..my consultants were saying that we cannot define our own profile.through Application Developer Resp.is it true ???
IF NO then "in ur article about PROFILE how u used XXpassi Profile.
kindly explain

 

Blogger Anil Passi said ... (7:20 AM) : 

Hi DK

Yes, you can create profile options from Application Developer, infact that is the only responsibility that allows creation of Profile Options.........

Thanks,
Anil

 

Anonymous Ashish said ... (2:32 AM) : 

Hi Anil,

Found your site.. its really so easy to follow what u describe...

Profile option till now was a mystery for me... u made me atleast have a starting understanding of the same..
great help ...

Thanks..
Ashish

 

Anonymous Anonymous said ... (9:17 PM) : 

The word is fantastic.

Anil Bhan

 

Blogger Anil Bhan said ... (9:29 PM) : 

Fanatis job Anil.I have been following your postins for a long time.

Anil Bhan

 

Anonymous eshan said ... (9:46 PM) : 

Hi Anil,

I am new to oracle Apps.Can you explain me the difference between user profile,security profile and system profile with examples ???

thanks for having come with such a useful site.

regards,
farha

 

Anonymous Anonymous said ... (1:10 PM) : 

it is very clear and useful. Thanks

 

Anonymous Anonymous said ... (8:49 PM) : 

Hi Anil
Thank you very much for sharing your knowledge and helping us to know more about Oracle Apps.

Thanks
Mitali

 

Anonymous shashank said ... (3:31 PM) : 

Hello Anil
You are amazing man!!!
By the way i was going through Profile Options..You said with out adding the Application Developer Responsibility we wont be getting that option called profile options under Application..
But when i was trying to define that responsibility it says "Application Developer is already in use.Please select a unique name".It doesn't make sense to me at all..If i have that responsibility why is it not showing Profile under application?? FYI: I have System Administrator and Order Management Responsibilities..Appreciate Your Help..Thanks!!

 

Anonymous John said ... (12:28 PM) : 

IF Oracle Apps was a religion
THEN Anil would have been God!

 

Anonymous Anonymous said ... (3:24 PM) : 

Hi Anil,

you are simply great. i have never seen such a nice explaination of anything.

Please keep your good work up.

thanks,

Regards,
Anshul singhal

 

Anonymous Anonymous said ... (7:58 AM) : 

u r great

 

Anonymous Anonymous said ... (10:27 PM) : 

Hi Anil,
Fantastic work...just to understand this profile option i have tried going thru so many books and articles...they are either overloaded with information else dont cover what is most essential...it was really gr8 going thru ur article...keep up the good work..

Thanks..
ag

 

Blogger Aishwarya said ... (10:29 PM) : 

Hi Anil,
Fantastic work...just to understand this profile option i have tried going thru so many books and articles...they are either overloaded with information else dont cover what is most essential...it was really gr8 going thru ur article...keep up the good work..

Thanks..
ag

 

Blogger Aishwarya said ... (4:11 AM) : 

Hi Anil,
When we go to Help -> Diagnostics,
in Apps, we find two things

$PROFILE$
and
PROFILE OPTIONS

What do they indicate?

Thanks in advance.

 

Blogger Anil Passi said ... (4:57 AM) : 

Hi A

In Help/Diagnostics/Examine, the block name $PROFILE$ caches the profile option values at the Form Startup for that user session.
Hence you can select BLOCK=$PROFILE$ and FIELD=PROFILE OPTION SHORT NAME

And hence the profile option value for that screen session will be shown in value field.

Thanks
Anil

 

Blogger blesson said ... (5:39 AM) : 

Great Work yar. Your are awesome. I really appreciate your effort on this.

 

Blogger Baleshwar said ... (6:20 AM) : 

gud work keep it up!!!

 

Anonymous Anonymous said ... (2:32 AM) : 

Hi Anil
Really this site is useful a lot.

One doubt When u were creating a profile u said for Clerk 5 and Smith 15, these values will be provided by whom?
What are these values?
Could you please explain?
Regards,
Pradeep.

 

Blogger kalpana said ... (4:45 AM) : 

Anil,
done a great job.

regards
kalpana

 

Blogger Babu B said ... (7:55 PM) : 

Hi,

Thanks a lot.

Good work. Keep it up.

Babu
http://babudba.blogspot.com

 

Blogger asha said ... (1:15 AM) : 

hi anil,
all this days i was like confussed abt the concept of Profile but this article made me so clear with the concepts.

Thanks...god bless!!

 

Blogger Aboothahir said ... (9:29 PM) : 

Hi,

Wat happens in a responsibility say clerk, Some clerks have the discount of 7.0 and some has 5.0?..
How can we do the profile option here?

 

Blogger Faisal said ... (10:32 PM) : 

Thanks a lot Anil, May Allah grant your the best of knowledge and its merits and guide you to what is right, Aameen. - Faisal

 

Anonymous Debanjan De said ... (8:05 PM) : 

Hi Anil,

Its a very nice explanation of profile options and extremely helpful material. I have a question, lets say I want to use a profile option directly in the Parameter form. Eg, I'll pass the OU name in the parameter, and for that I've a query and the org_id would be passed as parameter in it. How can I achieve it?

Regards,
Debanjan

 

Blogger DiNi said ... (2:41 AM) : 

hi anil,
Am a beginner in oracle apps functional consultant. please update about eAM module in your blog.


Thanks
Dinesh

 

Anonymous Anonymous said ... (11:15 AM) : 

Thank you very much ....This site is really helpful!!
Srikanth

 

Blogger yogesh said ... (7:20 AM) : 

Hi anil,
I have just started to work in Apps AP module.
I want to learn oracle Apps.
please give me some advice to start.

Thanks
Yogesh

 

Anonymous Kumar said ... (6:51 AM) : 

Hi Anil, Thanks a lot for a nice explanation.

Regards
Kumar

 

Anonymous Anonymous said ... (6:52 AM) : 

Hi Anil,

thanks a lot for a nice explanation

Regards
Kumar

 

Blogger Kumar said ... (6:55 AM) : 

Hi Anil,

Great explanation.

Thanks
Kumar

 

Anonymous Anonymous said ... (5:02 AM) : 

Thanks Anil,
U made it so easy.. i will go through your blog completely.. Hope to find more setups with screenshot.
Thanks
Nabil

 

Blogger Runa said ... (10:19 AM) : 

You r really great Anil!!
Thanks a lot!!

Shree

 

Blogger Runa said ... (10:23 AM) : 

You r simply great Anil!!
Thanks a lot!!
Shree

 

Anonymous Anonymous said ... (5:43 AM) : 

Its really great.thanks a lot
sanjeet

 

Blogger JYOTSNA said ... (8:20 AM) : 

You are simply geneous

 

Blogger JYOTSNA said ... (8:22 AM) : 

U r simply geneous....

 

Blogger ankur.soni said ... (12:29 AM) : 

hi Anil,

i have created one responsibility and assign only reports ,contains custom reports.and also created few users (suppose Mr. xx and Mr. yy and assigned the same responsibility to them but Mr. can see only his own request report but Mr. xx can see his report and also run by Mr.YY , i want to restrict Mr. XX to not allowed to see other users report

 

Blogger ankur.soni said ... (12:29 AM) : 

hi Anil,

i have created one responsibility and assign only reports ,contains custom reports.and also created few users (suppose Mr. xx and Mr. yy and assigned the same responsibility to them but Mr. can see only his own request report but Mr. xx can see his report and also run by Mr.YY , i want to restrict Mr. XX to not allowed to see other users report

 

Blogger krishna krishnan said ... (3:44 AM) : 

hi anil,
Your site is excellent. Keep on going good works. I appreciate ur work and patience. I have one query.... I have been working in Application for the last 2 years. Could you pls update me about "EAM" Module in your blog.


Thanks
A Radhakrishnan

 

Blogger krishna krishnan said ... (3:51 AM) : 

hi anil,
Your site is excellent. Keep on going good works. I appreciate ur work and patience. I have one query.... I have been working in Application for the last 2 years. Could you pls update me about "EAM" Module in your blog.


Thanks
A Radhakrishnan

 

Anonymous Anonymous said ... (3:34 PM) : 

Hi Anil,

Excellent posting..Can you also explain what does setting profiles at site, server, and organization level mean? Thank you

Regards,
Sandeep

 

Anonymous Jyotee said ... (11:43 AM) : 

Hi Anil,

How you doing?I am new to Oracle Apps and your blog.I can say that
You are simply Superb....you made
technology so simple I can say.

 

Anonymous Anonymous said ... (9:59 AM) : 

this is simply superb..u hv actualy made me understand the concepts...too good..

 

Blogger dilip said ... (12:56 PM) : 

Hi Anil

Thanks for your posting and Could you let me know which version of Apps they are currently using and also the all the versions of the Oracle Apps

 

Anonymous Anonymous said ... (1:00 PM) : 

Could you let me know all the versions of Apps they used

 

Blogger dilip said ... (10:11 PM) : 

Hi Anil

Really a great work and easy to learn for the begineers

 

Blogger dilip said ... (10:12 PM) : 

And Why do u we need Profile Option Name and User Profile Name

 

Blogger chetna said ... (7:21 AM) : 

Thanks a Ton Anil...
Articles are just so ready to be understood...
Great!!! Keep up the Good Work!!!

 

Anonymous Anonymous said ... (12:19 PM) : 

This is really useful article... I just want to understand.. If i define profile option at user level and application level both.. then fnd_profile will pick which value ?

 

Anonymous Student said ... (9:07 AM) : 

Hi Anil,

I have just started learning OraApps.
As I am new to the field, often I am not able to find the path to open the screen. Like to open Responsibility screen which Responsibility should be used and how to navigate.

Is there any simpler way to solve this silly problem. It kills half of my time in searching for the screen. :(

You are doing a gr8 job. God bless you.

Thanks.

 

Blogger Srinivas said ... (5:06 AM) : 

it is very easy to understand. Thanks to Mr. Anil> it is very useful to Beginers like me Thanks alot

Srinivas.P

 

Blogger Khaleel Shaik said ... (2:57 AM) : 

Hi Anil,

This is really helpful for me to understand the relation between the profile, user, and responsibility. The most valid point here is "Profile is a Global variable". It cleared my hundred questions that had in my mind before started reading this.

I have one more question what is the relation between ROLE and RESPONSIBILITY? Both feel same to me. Is the role like previlege and responsibility like role in the DB concepts?

Regards
Khaleel

 

Blogger Khaleel Shaik said ... (2:59 AM) : 

Hi,

This is really helpful for me to understand the relationship between USER, RESPONSIBILITY, AND PROFILE. The valid point here is Profile is a Global variable.

Thanks a ton.

Cheers
Khaleel

 

Anonymous Anonymous said ... (11:22 PM) : 

Thanks Anil for excellent work around on profile options.

 

Anonymous Anonymous said ... (12:39 AM) : 

Dear Anil,
Thanks for the information on Profiles..
In the Screen Shots of creating responsibilites and assigning the concerned profiles to the manager and clerk, It was shown how a profile should be created. But can you please tell me where that coding part has to be written for that 5% and 15% while creating the profile.. Could you please provide the screen shots for the same.

If possible kindly provide me some material for the Bigginers.

Thanks in advance Anil.

Warm Regards,
HARI

 

Anonymous Anonymous said ... (12:40 AM) : 

Sorry Anil I for got to give my email ID it is hari417ece@gmail.com

Regards,
HARI

 

Blogger VidyaSagar said ... (4:44 AM) : 

very excellent

 

Anonymous Anonymous said ... (6:06 AM) : 

Awesome dudee!!

 

Anonymous Anonymous said ... (7:16 AM) : 

hi Anil,

i am new to oracle apps, i understood the concept.

Can you please explain where the link is defined for the particular field (for example the discount field in order entry screen)

you have shown the profile name ,user/responsiblity against the value(5/15) but how it restricts the particular field in order entry screen

Thank you
Ram.G

 

Blogger Adil A Murad said ... (3:50 AM) : 

Anil you are Angel

 

Blogger Mani187 said ... (5:12 AM) : 

Hi Anil,
Really nice explanation and I have a small question regarding profile options.How do I know the max discount value? If I enter any value in the discount value column,how it can be showed an error.You already said that code and all,but what is the exact max permissible value of that particular column.Can you give the solution for this question.
Thanks in Advance...
Mani

 

Blogger Mani187 said ... (5:12 AM) : 

Hi Anil,
Really nice explanation and I have a small question regarding profile options.How do I know the max discount value? If I enter any value in the discount value column,how it can be showed an error.You already said that code and all,but what is the exact max permissible value of that particular column.Can you give the solution for this question.
Thanks in Advance...
Mani

 

Anonymous Anonymous said ... (1:12 PM) : 

Thank you.. :)

 

post a comment