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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.