1. Login as SYSADMIN
2. Navigate to 'User Management' responsibility.
2. Query the user that you want to grant access to all value sets
3. Grant the following role
Role = Flexfield Value Set Security: All
privileges
Code = UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE
Through Backend(with apps user)
Begin
WF_LOCAL_SYNCH.PROPAGATEUSERROLE
(p_user_name => 'XXUSERNAME',
p_role_name => 'UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE');
commit;
end;