{"id":12023,"date":"2014-10-29T12:19:46","date_gmt":"2014-10-29T12:19:46","guid":{"rendered":"http:\/\/erpschools.com\/?p=12023"},"modified":"2014-10-29T12:20:25","modified_gmt":"2014-10-29T12:20:25","slug":"value-set-security-feature-in-12-2-and-above-versions","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions","title":{"rendered":"Value set security feature in 12.2 and above versions"},"content":{"rendered":"

Oracle has introduced a new value set security feature \u00a0in 12.2 version which will disable accessing value set values to all users. This is default functionality and Business users are expected to give permissions either to specific value sets or all value sets to specific users or group of users.<\/p>\n

Let’s backup a little bit and compare the value set security in 11i(or 12.0) to 12.2 version<\/p>\n

In both 11i version and 12.0 version of Oracle ERP, Every user who has access to value set form or value set values form can access the values. We can restrict the value set values by creating security rules.
\nSo here, by default no security is applied, and users have the option to apply the security feature.<\/p>\n

In 12.2 version and above Users can not access value set values by default. Users are allowed to create value sets but not value set values.
\nSo here, by default security is enabled and we need to release the security for a group of people or responsibilities.<\/p>\n

I will demonstrate who to provide access to all value sets to a specific user account.<\/p>\n

Step1<\/strong>: Login as SYSADMIN user (any other user with system administrator privileges)<\/p>\n

Step2:<\/strong> Navigate to Functional Developer Responsibility (If you don’t have this responsibility, assign it)<\/p>\n

Step3:<\/strong> Under security > Grants search for \u201cFlexfield Value Set Security Object\u201d as shown in below pic<\/p>\n

\"Flexfield
\nOnce you find the object click on Update Button and
\nGo to Grants Tab and click “Create Grant” button , highlighted in below image.<\/p>\n

\"Flexfield<\/p>\n

Step4:\u00a0<\/strong>Create Grant<\/p>\n

Enter the information as below including the USERNAME to which you\u00a0would like to provide access to all value sets<\/p>\n

\"Flexfield_valueset_security_Define_Grant\"<\/p>\n

Click Next<\/p>\n

Step5:<\/strong> Define Context<\/p>\n

Here we are providing access to all value sets. If you wish you can create your own instance set just for few value sets.<\/p>\n

\"Flexfield_Select_Object_Data_Context\"<\/p>\n

Step6:\u00a0<\/strong>Last step, Specify what kind of privileges you would like to provide<\/p>\n

You can choose, View only, insert only, update only, Insert \/ Update<\/p>\n

 <\/p>\n

\"Oracle_Applications_-_Define_Object_Parameters_and_Select_Set\"<\/p>\n

 <\/p>\n

Done.<\/p>\n

Login as PRUDHVI (or any user you have mentioned in Step4) and navigate to value set values form either in Application Developer or system administrator or any other responsibility and you will be able to access value set values.<\/p>\n

\"Oracle_Applications_-value_Sets\"<\/p>\n

Happy Learning.<\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle has introduced a new value set security feature \u00a0in 12.2 version which will disable accessing value set values to all users. This is default functionality and Business users are expected to give permissions either to specific value sets or all value sets to specific users or group of users. Let’s backup a little bit […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[484,485,483,265,395,459],"class_list":["post-12023","post","type-post","status-publish","format-standard","hentry","category-sysadmin-and-aol","tag-12-2","tag-access","tag-new-feature","tag-security","tag-value-set","tag-values"],"yoast_head":"\nValueset security feature in Oracle ERP 12.2<\/title>\n<meta name=\"description\" content=\"Oracle Corp has introduced a new security feature in 12.2 version which disables access to value set values by default to all users and responsibilities\" \/>\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\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Value set security feature in 12.2 and above versions\",\"datePublished\":\"2014-10-29T12:19:46+00:00\",\"dateModified\":\"2014-10-29T12:20:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions\"},\"wordCount\":377,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png\",\"keywords\":[\"12.2\",\"access\",\"new feature\",\"security\",\"value set\",\"values\"],\"articleSection\":[\"Sysadmin and AOL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions\",\"url\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions\",\"name\":\"Valueset security feature in Oracle ERP 12.2\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png\",\"datePublished\":\"2014-10-29T12:19:46+00:00\",\"dateModified\":\"2014-10-29T12:20:25+00:00\",\"description\":\"Oracle Corp has introduced a new security feature in 12.2 version which disables access to value set values by default to all users and responsibilities\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png\",\"width\":1367,\"height\":384},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Value set security feature in 12.2 and above versions\"}]},{\"@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":"Valueset security feature in Oracle ERP 12.2","description":"Oracle Corp has introduced a new security feature in 12.2 version which disables access to value set values by default to all users and responsibilities","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\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Value set security feature in 12.2 and above versions","datePublished":"2014-10-29T12:19:46+00:00","dateModified":"2014-10-29T12:20:25+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions"},"wordCount":377,"commentCount":1,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png","keywords":["12.2","access","new feature","security","value set","values"],"articleSection":["Sysadmin and AOL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions","url":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions","name":"Valueset security feature in Oracle ERP 12.2","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png","datePublished":"2014-10-29T12:19:46+00:00","dateModified":"2014-10-29T12:20:25+00:00","description":"Oracle Corp has introduced a new security feature in 12.2 version which disables access to value set values by default to all users and responsibilities","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#primaryimage","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Object_Search.png","width":1367,"height":384},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/value-set-security-feature-in-12-2-and-above-versions#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Value set security feature in 12.2 and above versions"}]},{"@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\/12023","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=12023"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/12023\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=12023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=12023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=12023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}