{"id":4650,"date":"2014-03-22T21:53:52","date_gmt":"2014-03-22T16:23:52","guid":{"rendered":"http:\/\/erpschools.com\/?p=4650"},"modified":"2014-03-22T21:53:52","modified_gmt":"2014-03-22T16:23:52","slug":"profile-option-in-oracle-apps","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps","title":{"rendered":"Profile Option in Oracle Apps"},"content":{"rendered":"<p>Profile Option in Oracle Apps:<\/p>\n<p>Profile Option values control the behavior of Oracle Apps, in other words they determine how Oracle Apps should run. The value for a profile option can be changed any time.<\/p>\n<p>For Example we have a profile option called MO: Operating Unit. Assigning a value to this profile option will determine what operating unit it should use when a user gets into a particular responsibility.<\/p>\n<p>We have two types of Profile options &#8211; System and Personal profile options depending on to whom they are visible and who can update their values.<\/p>\n<p><span style=\"text-decoration: underline;\">System Profile options<\/span> are visible and can be updated only in System Administrator responsibility. In short they will be maintained by a System Administrator only.<\/p>\n<p><span style=\"text-decoration: underline;\">User Profile Options<\/span> are visible and can be updated by any end user of Oracle Apps.<\/p>\n<p>Profile Options can be set at different levels. Site level being the highest and User being the lowest in the heirarchy. If a profile option is assigned at two levels, then value assigned at lowest\u00a0level takes the precedence.<\/p>\n<ul>\n<li>Site (restricted to the whole of Apps)<\/li>\n<li>Application ( restricted only to a particular application like Payables, Receivables)<\/li>\n<li>Responsibility (restricted only to a particular responsibility)<\/li>\n<li>Organization (restricted to a particular organization)<\/li>\n<li>User (restricted to a user)<\/li>\n<\/ul>\n<p>Now let&#8217;s see how to create a new profile option and assign a value to it.<br \/>\nSay you want to create a profile option called erpSchools Debug and the possible values that the user can choose are Yes, No. If the user chooses Yes, then the custom concurrent program will print all the debug messages otherwise the debug messages will not printed in the log file of the concurrent request.<\/p>\n<p><span style=\"text-decoration: underline;\">Creating a Profile Option:<\/span><br \/>\nNavigation: Application Developer &gt; Profile<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4651\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png\" alt=\"PO1\" width=\"366\" height=\"235\" \/><\/p>\n<p>Profiles window will open up where you enter the below details:<br \/>\nName: Give a meaningful and unique name for this profile option<\/p>\n<p>Application: Enter the application for which this profile option will be used like Payables, Receivables etc. If it is for a custom program then choose the custom application.<\/p>\n<p>User Profile Name: Again enter a meaningful and unique name. This is the name that the users will see in the Profile Options window.<\/p>\n<p>Description: Enter the purpose or usage of this option.<\/p>\n<p>Heirarchy Type Access Levels: At what levels this profile option should be visible and updatable.<\/p>\n<p>Active dates: Enter the dates on which the profile option becomes active\/inactive<br \/>\nUser Access:<\/p>\n<p>Visible &#8211; Determines whether your end users can see and query this profile option in their personal profiles. Otherwise, they cannot query or update values for this option.<\/p>\n<p>Updatable &#8211; Determines whether your end users can change the value of this profile option using their Profile Values window. Otherwise, your system administrator must set values for this profile option.<\/p>\n<p>SQL Validation: You can write up a SQL statement to display the selected rows in LOV. If this section is left blank, there will no LOV instead the user can enter any free text as value.<br \/>\n<a href=\"http:\/\/erpschools.com\/articles\/sql-validation-used-for-profile-options-list-of-values\"> Click here to know more about SQL Validation rules <\/a><\/p>\n<p>Save the work.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4652\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO2.png\" alt=\"PO2\" width=\"760\" height=\"541\" \/><\/p>\n<p><span style=\"text-decoration: underline;\">Assign a value to the profile option<\/span>:<br \/>\nNavigation: System Administrator &gt; Profile &gt; System<br \/>\nEnter the below when the window opens and click on Find button<br \/>\nUnder Display section, Choose at what level you want to assign a value.<br \/>\nIn the Find field, enter the profile option name to which you want to assign the value.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4653\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO3.png\" alt=\"PO3\" width=\"581\" height=\"396\" \/><br \/>\nEnter the value that you want to assign to profile option at the appropriate level and save.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4654\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO4.png\" alt=\"PO4\" width=\"996\" height=\"195\" \/><\/p>\n<p><span style=\"text-decoration: underline;\">To derive a value of profile option from PL\/SQL procedure<\/span>:<br \/>\nWe have seen how to create and assign value to profile option. Most of the times, custom concurrent program will need to get the value of a profile option that will determine its course of actions. You will use API called FND_PROFILE.<\/p>\n<p>1.To get the value of profile option:<br \/>\n<code>select FND_PROFILE.value('ERPSCHOOLS DEBUG') from dual; <\/code><br \/>\nRemember to pass on the name of the profile option and not the user profile name here.<\/p>\n<p>2. To set value to profile option from PL\/SQL procedure:<code><br \/>\nBEGIN<br \/>\nFND_PROFILE.put ('ERPSCHOOLS DEBUG','No');<br \/>\nEND;<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Profile Option in Oracle Apps: Profile Option values control the behavior of Oracle Apps, in other words they determine how Oracle Apps should run. The value for a profile option can be changed any time. For Example we have a profile option called MO: Operating Unit. Assigning a value to this profile option will determine [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,8],"tags":[213,214],"class_list":["post-4650","post","type-post","status-publish","format-standard","hentry","category-articles","category-sysadmin-and-aol","tag-profile-option","tag-profile-option-value"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Profile Option in Oracle Apps - erpSchools<\/title>\n<meta name=\"description\" content=\"Profile Option in Oracle Apps\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Profile Option in Oracle Apps\",\"datePublished\":\"2014-03-22T16:23:52+00:00\",\"dateModified\":\"2014-03-22T16:23:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps\"},\"wordCount\":675,\"commentCount\":8,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png\",\"keywords\":[\"Profile Option\",\"Profile option Value\"],\"articleSection\":[\"Articles\",\"Sysadmin and AOL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps\",\"url\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps\",\"name\":\"Profile Option in Oracle Apps - erpSchools\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png\",\"datePublished\":\"2014-03-22T16:23:52+00:00\",\"dateModified\":\"2014-03-22T16:23:52+00:00\",\"description\":\"Profile Option in Oracle Apps\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Profile Option in Oracle Apps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Profile Option in Oracle Apps - erpSchools","description":"Profile Option in Oracle Apps","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Profile Option in Oracle Apps","datePublished":"2014-03-22T16:23:52+00:00","dateModified":"2014-03-22T16:23:52+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps"},"wordCount":675,"commentCount":8,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png","keywords":["Profile Option","Profile option Value"],"articleSection":["Articles","Sysadmin and AOL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps","url":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps","name":"Profile Option in Oracle Apps - erpSchools","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png","datePublished":"2014-03-22T16:23:52+00:00","dateModified":"2014-03-22T16:23:52+00:00","description":"Profile Option in Oracle Apps","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/PO1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/articles\/profile-option-in-oracle-apps#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Profile Option in Oracle Apps"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=4650"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4650\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=4650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=4650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=4650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}