1 Reply Latest reply on Jul 17, 2015 7:56 AM by Daan Bakboord - DaAnalytics

    How to see Data for an Oracle apps view

    KN

      Hello Experts,

       

      I need to import a Oracle Apps view in to RPD. I can only see data from an view if I execute the below queries in that session. I have added them in pre-execute connection scripts but i am getting error but i am able to execute the same in SQL Developer with same user what i use in RPD logon. Any Clue?

       

       

      ###################################################

      begin

      apps.MO_GLOBAL.SET_POLICY_CONTEXT('S',201); -- pass in the organization id

      end ;

       

      alter session set nls_language='American';

       

      ###################################################

       

      Thanks,

      KN