3 Replies Latest reply: Sep 28, 2006 12:16 PM by 144341 RSS

    MULTI-ORG VIEW DOES NOT RETURN DATA THRU DB LINK

    355999
      I have database view based on mult-org views e.g., OE_ORDER_HEADERS. When I
      execute FND_CLIENT_INFO.set_org_context('83'), then I select from the view it
      returns data. But, when I have a db link on the view, then when a select is
      done on the view from the remote database, no data is returned. What are my
      options to make the view return data and still maintain multi-org security?