We have been building an application in APEX 4.2 theme 24 Oracle 11g, this is our first application and has not been in a production environment yet. It consists of 2 applications in the same workspace that the users can navigate to.
We have just upgraded these 2 applications to APEX 5.04 (same theme) on another database Oracle 12c. In 4.2 Edit application properties >> User Interfaces, I could set the Home URL and Login URL. I cannot find this in APEX 5. In APEX 5 I can see the login URL in the view: APEX_APPLICATIONS LOGIN_URL. It has the same value as it was pre-upgrade. My question - is it accessible to be changed in the application builder in APEX 5.0 or was it set in configuration/migration - I myself did not do the upgrade/migration. The reason I am asking is because, I need to change the application alias. Also I need to know if I can rely on the value in view APEX_APPLICATIONS LOGIN_URL to access it for navigation between the applications without hard-coding the URL's - if there is a better way to find the URL's please let me know also.
I see that in the APEX_UTIL there is a function HOST_URL is that something I should check into using?
Thanks in advance.
Therese S.