f Get Oracle Apps Traning Here: Profile Options Examples Screenshots
Main Menu
Techie or Funcy ?
Prerequisites
Training Index   

Interview Qns
Apps Interview Qns
HRMS Interview Qns

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



About Me

Name:
Location: United Kingdom

The desire to be extraordinary is a very ordinary desire. To relax and to be ordinary is really extraordinary

  • Subscribe for Emails

    • Previous Posts

    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

    posted by Anil Passi at 5:12 PM

    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 Anonymous 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 chandu 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 Unknown 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 Unknown 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 Unknown 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 S 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 S 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 Anonymous 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 Anonymous 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 Anonymous 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 Anonymous 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 Anonymous 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 Unknown 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 Unknown 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 Unknown said ... (4:45 AM) : 

    Anil,
    done a great job.

    regards
    kalpana

     

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

    Hi,

    Thanks a lot.

    Good work. Keep it up.

    Babu
    http://babudba.blogspot.com

     

    Blogger Asha John 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 Anonymous 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 DiN 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 Unknown 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 Anonymous 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 Unknown said ... (8:20 AM) : 

    You are simply geneous

     

    Blogger Unknown 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 Unknown 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 Unknown 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 davis 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 davis said ... (10:11 PM) : 

    Hi Anil

    Really a great work and easy to learn for the begineers

     

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

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

     

    Blogger Unknown 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 Andala 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 Mani 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 Mani 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