How to get to know access URL from the database level

Hi @Alex ,

Since you have access to the DB, you can potentially use the SQL below to get the URL.

SELECT VALUE
FROM fnd_setting
WHERE parameter ='SYSTEM_URL'

cheers

Thanks for this. So there is no more use of plsqlap_environment_tab table in case of cloud installation? My plsqlap_environment_tab has no records so I was wondering if there had been a middleware server installed against that database. And indeed your query from fnd_setting is giving me the URL, which allows me to login as ifsadmin, however there are errors and no navigator after I log in.

Finally I grabbed another working cloud installation and plsqlap_environment_tab seems not being used anymore.