Toad World® Forums

views are not displaying data in toad 12.9


#1

Hi All… I am using Oracle 12c and Toad 12.9… If i am doing select * from fnd_amp_requests_v ; Or select * from fnd_lookups and many more then its not displaying any data. But the view or table is defined there if i do F4.

Meanwhile slect * from mtl_system_item_b and many more are working correctly. Can anyone suggest what could be the problem please.


#2

Not sure, without more details. Guessing that it might be related to whether or not you have privs on retrieving from the views.

In any event, probably best to open up a quick Support ticket to let the Engineers look at this.