What is FlexField Value Set Security Oracle Apps R12.2 (EBS)

 What is FlexField Value Set Security

• FlexField Value Set Security is on the definition or setup side of Value Set Values

• This is the ability to restrict who can view, add or update Value Set Values

• Specifically who can use the Segment Values form (FNDFFMSV) for which specific Value

Sets

• This functionality started in R12.2.2

Quick Simple Fix

• There is a way to get back to the pre-R12.2 functionality quickly

• This is a slam dunk approach, it does not take advantage of the new functionality, but it gets you back in business

quickly with the old functionality

• This quick fix can be undone later when you are ready to tackle this properly

Steps

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.