R12.2 FlexField Value Set Security

 R12.2 FlexField Value Set Security

FlexField value set security is a new feature in R12.2.2 that allows you to determine which roles can access which value set values. This allows you delegate GL Value Set Value maintenance to one set of functional users, while allowing Item Category Value Set Values to be maintained by another. Often people just take the slam dunk approach of assigning the role ‘FlexField Value Set Security: All privileges’, allowing a user access to all value sets. 

We will also discuss the use of the wizard ‘FlexField Value Sets: Security Administration Setup’

 1) Need to login as SYSADMIN 

2) Select the "User Management" responsibility 

3) Navigate to "User” 

4) Find the particular user then click on update icon 

5) Click on "Assign Role”

 6) Select "Role" as search by and enter value as "Flexfield Value Set Security: All privileges” Or Select "Code" as search by and enter value as"UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE" 

7) Select the role from result 

8) Enter a justification text. 

9) Click on "Apply”

 10) Clear the cache from functional administrator responsibility if required.

Script to Provide the access from Backend(with apps user)

Begin

  WF_LOCAL_SYNCH.PROPAGATEUSERROLE(p_user_name => 'XYZ',

      p_role_name => 'UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE');

  commit;

end;

References -

Doc id 1612727.1 "Flexfield Value Sets Do Not Appear in List of Values (LOV) in Oracle E-Business Suite Release 12.2 on Segment Values Form FNDFFMSV

http://www.jrpjr.com/paper_archive/R12.2%20Flexfield%20Value%20Set%20Security.pdf