Value set security feature in 12.2 and above versions


Oracle has introduced a new value set security feature  in 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 and compare the value set security in 11i(or 12.0) to 12.2 version

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.
So here, by default no security is applied, and users have the option to apply the security feature.

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.
So here, by default security is enabled and we need to release the security for a group of people or responsibilities.

I will demonstrate who to provide access to all value sets to a specific user account.

Step1: Login as SYSADMIN user (any other user with system administrator privileges)

Step2: Navigate to Functional Developer Responsibility (If you don’t have this responsibility, assign it)

Step3: Under security > Grants search for “Flexfield Value Set Security Object” as shown in below pic

Flexfield Valueset Security
Once you find the object click on Update Button and
Go to Grants Tab and click “Create Grant” button , highlighted in below image.

Flexfield Valueset Security grant

Step4: Create Grant

Enter the information as below including the USERNAME to which you would like to provide access to all value sets

Flexfield_valueset_security_Define_Grant

Click Next

Step5: Define Context

Here we are providing access to all value sets. If you wish you can create your own instance set just for few value sets.

Flexfield_Select_Object_Data_Context

Step6: Last step, Specify what kind of privileges you would like to provide

You can choose, View only, insert only, update only, Insert / Update

 

Oracle_Applications_-_Define_Object_Parameters_and_Select_Set

 

Done.

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.

Oracle_Applications_-value_Sets

Happy Learning.