I have a problem where sql developer is not returning data from some tables..
For example, SQL> select * from fnd_lookups;
The query results shows the column headings but no data.
I also run select count(*) from fnd_lookups; and it shows 0 records.
However other tables will return data. e.g. SQL> select * from fnd_lookup_values;
I can use SQL from a unix session and I can see data in the table.
e.g. SQL> select count(*) from fnd_lookups;
I have asked several colleagues to try it and all of them can see data from the table, We all used the same instance, and user.
The problem is specific to my install of SQL developer.
I used autotrace when I query from the table I see the following.
The only difference from my colleagues that don't have the problem is they only see the following "SECURITY_GROUP_ID=FND_GLOBAL" while mine has the following:
Are there any settings in SQL developer that I may have accidentally set that enabled this security?