Wednesday, March 13, 2019

Unable to Create/Update/Delete/View Value Set Values in Oracle EBS R12.2


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

5 comments:

  1. AbhayaJune 2, 2020 at 8:55 AM

    This Might Help from Back end :
    BEGIN
    wf_local_synch.PropagateUserRole(p_user_name =>'USERNAME',p_role_name =>'UMX|ROLE NAME XXXXXXX))');
    END;

    ReplyDelete
  2. Alice SmithNovember 2, 2026 at 9:16 PM

    This comment has been removed by the author.

    ReplyDelete
  3. Alice SmithNovember 2, 2026 at 9:19 PM

    This comment has been removed by the author.

    ReplyDelete
  4. Alice SmithNovember 2, 2026 at 9:45 PM

    Thanks for sharing such an insightful read—the insights here are spot on. Engaging experienced Oracle E Business Suite consulting is invaluable for enterprises maintaining complex, customized ERP footprints. Whether planning hybrid cloud integrations, executing long-term version upgrades, or optimizing custom database objects, strategic guidance ensures ongoing system reliability while charting a clear modernization path.

    ReplyDelete

Subscribe to: Post Comments (Atom)