Skip to main content

I have a database access i.e. I can login as IFSAPP. This is a cloud installation I believe. How can I verify Aurena URL accessing this database?

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.

Reply


Terms & ConditionsCookie settings