Issue :- Update In R12.2
=========================
Value sets do not appear in the List of Values (LOV) in the Values form FNDFFMSV after upgrading to Oracle E-Business Suite 12.2.
Users are not able to insert or update any independent or dependent value set values after the upgrade.
Solution
=================
1. Login as SYSADMIN and navigate to 'User Management' responsibility.
2. Query the user that you want to grant access to all value sets > and grant the following role
Role = Flexfield Value Set Security: All privileges
Code = UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE
This Might Help from Back end :
ReplyDeleteBEGIN
wf_local_synch.PropagateUserRole(p_user_name =>'USERNAME',p_role_name =>'UMX|ROLE NAME XXXXXXX))');
END;
Thanks
Delete