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

92 comments:

  1. Anonymous7:12 AM

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

    thanks a ton!

    regards,
    viplendra

    ReplyDelete
  2. Anonymous12:43 PM

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

    Artur bakhtriger

    ReplyDelete
  3. Anonymous12: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

    ReplyDelete
  4. Anonymous9:55 PM

    THANKS A TON!

    SANDY

    ReplyDelete
  5. Anonymous6:13 AM

    HI

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

    Ritz

    ReplyDelete
  6. Hi Ritz

    this is from 11.5.10

    thanks
    anil

    ReplyDelete
  7. Hi Anil,

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

    thanks
    Muskan

    ReplyDelete
  8. Hi Muskan

    Good to hear that this site is helping you.

    Thanks,
    Anil

    ReplyDelete
  9. Anonymous12:19 AM

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

    ReplyDelete
  10. 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.

    ReplyDelete
  11. 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

    ReplyDelete
  12. 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?

    ReplyDelete
  13. 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

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

    Thanks a lot..
    its really helping too much

    ReplyDelete
  15. Anonymous5: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

    ReplyDelete
  16. Anonymous8:46 AM

    Hi Anil ,

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

    Regards
    Ankit

    ReplyDelete
  17. 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

    ReplyDelete
  18. 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

    ReplyDelete
  19. 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

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

    Regards
    madhu

    ReplyDelete
  21. Anonymous10:35 PM

    Hi Anil,


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


    Bharat

    ReplyDelete
  22. Anonymous11:31 PM

    Hi Anil,

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

    regards
    J.Siva Kumar

    ReplyDelete
  23. Anonymous11:09 PM

    Hi Anil,

    Great Job ! Thanks a ton !

    Regards,

    Nisarg

    ReplyDelete
  24. Anonymous1: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

    ReplyDelete
  25. Anonymous2:33 AM

    Hi Anil,

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

    ReplyDelete
  26. Anonymous12:34 PM

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

    ReplyDelete
  27. Anonymous6: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

    ReplyDelete
  28. Hi Radhika

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

    Thanks,
    Anil

    ReplyDelete
  29. 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

    ReplyDelete
  30. 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

    ReplyDelete
  31. Anonymous2: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

    ReplyDelete
  32. Anonymous9:17 PM

    The word is fantastic.

    Anil Bhan

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

    Anil Bhan

    ReplyDelete
  34. Anonymous9: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

    ReplyDelete
  35. Anonymous1:10 PM

    it is very clear and useful. Thanks

    ReplyDelete
  36. Anonymous8:49 PM

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

    Thanks
    Mitali

    ReplyDelete
  37. Anonymous3: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!!

    ReplyDelete
  38. Anonymous12:28 PM

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

    ReplyDelete
  39. Anonymous3: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

    ReplyDelete
  40. Anonymous7:58 AM

    u r great

    ReplyDelete
  41. Anonymous10: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

    ReplyDelete
  42. 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

    ReplyDelete
  43. 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.

    ReplyDelete
  44. 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

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

    ReplyDelete
  46. gud work keep it up!!!

    ReplyDelete
  47. Anonymous2: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.

    ReplyDelete
  48. Anil,
    done a great job.

    regards
    kalpana

    ReplyDelete
  49. Hi,

    Thanks a lot.

    Good work. Keep it up.

    Babu
    http://babudba.blogspot.com

    ReplyDelete
  50. 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!!

    ReplyDelete
  51. 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?

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

    ReplyDelete
  53. Anonymous8: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

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


    Thanks
    Dinesh

    ReplyDelete
  55. Anonymous11:15 AM

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

    ReplyDelete
  56. 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

    ReplyDelete
  57. Anonymous6:51 AM

    Hi Anil, Thanks a lot for a nice explanation.

    Regards
    Kumar

    ReplyDelete
  58. Anonymous6:52 AM

    Hi Anil,

    thanks a lot for a nice explanation

    Regards
    Kumar

    ReplyDelete
  59. Anonymous6:55 AM

    Hi Anil,

    Great explanation.

    Thanks
    Kumar

    ReplyDelete
  60. Anonymous5: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

    ReplyDelete
  61. You r really great Anil!!
    Thanks a lot!!

    Shree

    ReplyDelete
  62. You r simply great Anil!!
    Thanks a lot!!
    Shree

    ReplyDelete
  63. Anonymous5:43 AM

    Its really great.thanks a lot
    sanjeet

    ReplyDelete
  64. You are simply geneous

    ReplyDelete
  65. U r simply geneous....

    ReplyDelete
  66. 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

    ReplyDelete
  67. 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

    ReplyDelete
  68. 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

    ReplyDelete
  69. 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

    ReplyDelete
  70. Anonymous3: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

    ReplyDelete
  71. Jyotee11: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.

    ReplyDelete
  72. Anonymous9:59 AM

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

    ReplyDelete
  73. 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

    ReplyDelete
  74. Anonymous1:00 PM

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

    ReplyDelete
  75. Hi Anil

    Really a great work and easy to learn for the begineers

    ReplyDelete
  76. And Why do u we need Profile Option Name and User Profile Name

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

    ReplyDelete
  78. Anonymous12: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 ?

    ReplyDelete
  79. Student9: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.

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

    Srinivas.P

    ReplyDelete
  81. 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

    ReplyDelete
  82. 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

    ReplyDelete
  83. Anonymous11:22 PM

    Thanks Anil for excellent work around on profile options.

    ReplyDelete
  84. Anonymous12: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

    ReplyDelete
  85. Anonymous12:40 AM

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

    Regards,
    HARI

    ReplyDelete
  86. Anonymous6:06 AM

    Awesome dudee!!

    ReplyDelete
  87. Anonymous7: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

    ReplyDelete
  88. 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

    ReplyDelete
  89. 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

    ReplyDelete
  90. Anonymous1:12 PM

    Thank you.. :)

    ReplyDelete