I have a problem in showing value on page item of oracle apex 20.
I write a query by selecting a view created from a table db link. I run it on DB, it is fine. I try it on object browser of oracle apex, it shows me data. But when I run same query on select list, modal lov, interactive report, it returns nothing. I don’t understand why that reason is. Thank you for your time and in advance.