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

thatJeffSmith-Oracle

Maybe something is happening in your other session that is NOT happening in your SQL Developer session - this may trigger a security feature in the database.

Are there any scripts you run in your other tool when you connect (login.sql), or perhaps there is a logon trigger in play?

tanmalhot

Not really Jeff.

The only difference is Windows OS vs Mac OS. I see issue in Mac OS version only.

thatJeffSmith-Oracle

there must be something else - the db could care less what OS the client session is originating from