1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

[Cloud ERP ] Restrict supplier LOV based on logged in users business unit

Discussion in 'Oracle Financials' started by vasanth, May 9, 2015.

  1. vasanth

    vasanth Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    75
    Hi ,



    In Procurement Purchase Order page , there is a Supplier LOV in the search page which lists all the supplier by Default.

    We have requirement to list only the suppliers based on the logged-in user's Business Unit Id and not all.


    Can we achieve the same through Fusion Personalization / Customization or through Data Security in a cloud instance?



    P.S : In cloud instance , is it possible to restrict the data shown in an LOV or ADF Table in a standard Fusion page through Customization?



    Thanks,
    Vasanth
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Yes Vasanth, you can do this with customization. Can you please open the page in jdeveloper and see the sql to restrict it.
     
  3. vasanth

    vasanth Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    75
    Hi Bharat ,

    Thanks for your inputs. Its a cloud instance , so we don't have access to any code base or Jdeveloper. So only access we have is the Fusion ERP Login. I wanted to know , if we can achieve the same through the customization option like Page Composer/Application composer/ Data Composer or through any other methodology from Fusion UI.

    Thanks,
    Vasanth