Forum Stats

  • 3,782,072 Users
  • 2,254,590 Discussions
  • 7,879,906 Comments

Discussions

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

tanmalhot
tanmalhot Member Posts: 2 Red Ribbon
edited Jan 29, 2019 10:27AM in SQL Developer

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

Answers