3 Replies Latest reply on Jan 29, 2019 3:27 PM by thatJeffSmith-Oracle

    Unable to view data in any of the view objects available in schema that I have access to

    tanmalhot

      I am trying to access data of a view fnd_flex_values_vl using Sql developer for Mac OS.

       

      If I run a simple select query in Toad on windows machine, it is retrieving data whereas same sql is not fetching any data in Mac OS.

      Same query runs on another colleague's sql developer app on windows 10 os.

       

      Is there any environment that needs to be set to allow data to be fetched?

      If I use actual sql used to generate view, data is present in both tables - fnd_flex_values_tl and fnd_flex_values.

       

      Please help.

       

      Regards

      TM