Hello
I have upgraded from 5.0.3 to 18.2 and glad I did. But there are couple of issues that appeared in my original application and generally, that I need to resolve.
At the end of script, installation was on hold for a while at:
timing for: Enabling Phase 3
#
# Computing Pub Syn Dependents
#
PL/SQL procedure successfully completed.
Then after hold, it just quit SQL Plus. Instead of getting "Thank you for installing Oracle Application Express." message.
But when verifying with:
SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX'; I got VALID result.
Couple things...

Whenever I try to pick icon from popup to get selection, it doesn't work. For button in this case, typing fa-download will show the icon on a button, but I expected to get list of icons from upward arrow popup. For some reason it doesn't respond when I click it.
Which brings me to another icon related question - in APEX 5, if I wanted to use icon for column's Link Text in a report, I would use: <span class="t-Icon fa-edit" style="color:#1f1f14"></span>
Now I tried <span class="fa fa-edit" style="color:#1f1f14"></span> and <span class="fa fa-edit" aria-hidden="true"></span> - this does not work - it will just show blank. I need the icon here for ID columns which link from row to other page, etc. How can I refer to icons in such cases?
If I use icon though HTML Expression for column like: <span class="fa fa-check"></span> then its showing fine.
Edit: I've dealt with that, just needed to switch from Font Awesome to Font Apex in theme settings, and that resolved all issues above.
- there aren't many things that weren't retained properly from old APEX 5 app. But some examples are, same in both the unmodified theme copy and copy where I fully applied new UT from APEX 18.2:
-on a page with On Load action that worked in APEX 5.0, I now get Javascript warning, and when viewing through console, it seems its partly related to deprecation:
Failed to load resource: net::ERR_BLOCKED_BY_CLIENT googleads.g.doubleclick.net/pagead/id:1
Failed to load resource: net::ERR_BLOCKED_BY_CLIENT ad_status.js:1
[Deprecation] Synchronous desktop_all.min.js?v=18.2.0.00.12:4 XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check https://xhr.spec.whatwg.org/.
Uncaught TypeError: Cannot set property f?p=118:74:7390500469543::::::4218 'disabled' of null
at EnableItems (f?p=118:74:7390500469543::::::4218)
at PageStart (f?p=118:74:7390500469543::::::4196)
at Object.javascriptFunction (f?p=118:74:7390500469543::::::4172)
at Object.da.doAction (desktop\_all.min.js?v=18.2.0.00.12:23)
at Object.da.doActions (desktop\_all.min.js?v=18.2.0.00.12:23)
at HTMLButtonElement.\<anonymous> (desktop\_all.min.js?v=18.2.0.00.12:23)
at Function.each (desktop\_all.min.js?v=18.2.0.00.12:2)
at a.fn.init.each (desktop\_all.min.js?v=18.2.0.00.12:2)
at Object.da.actions (desktop\_all.min.js?v=18.2.0.00.12:23)
at Object.\<anonymous> (desktop\_all.min.js?v=18.2.0.00.12:23)
www-embed-player.js:377 GET https://googleads.g.doubleclick.net/pagead/id net::ERR_BLOCKED_BY_CLIENT
Ge @ www-embed-player.js:377
Fe @ www-embed-player.js:362
(anonymous) @ www-embed-player.js:621
K @ www-embed-player.js:250
pi @ www-embed-player.js:618
(anonymous) @ www-embed-player.js:635
www-embed-player.js:377 GET https://googleads.g.doubleclick.net/pagead/id net::ERR_BLOCKED_BY_CLIENT
"Cannot set property 'disabled'...of null" is related to the Global JS Function I have defined as:
function PageStart(){
if($x("P74_NAME").value == "" || $x("P74_LAST_NAME").value == "") {
DisableItems();
} else {
EnableItems();
};
};
function DisableItems()
{
document.getElementById('P74_SOME_ITEM1').disabled=true;
document.getElementById('P74_SOME_ITEM2').disabled=true;
};
function EnableItems()
{
document.getElementById('P74_SOME_ITEM1').disabled=false;
document.getElementById('P74_SOME_ITEM2').disabled=false;
};
Then on Execute When Page Loads I have this function running: PageLoad();
which should disable some items on page, on load. Until P74_NAME, P74_LAST_NAME are filled in and certain button is clicked, then DA executes to enable the rest of the items. But when I use PageLoad(); function to execute, I get the JS warning/error, and none of the items are disabled, which means PageLoad() function doesn't work. I get JS error on other page as well which worked in previous APEX version, but I'll open that later as separate thread, until this is resolved. Is this anything deprecation related, when I made copy of original app and subsribed it to new APEX UT?
- Only in copy of app retained from APEX 5 with new UT theme (applied per https://apex.oracle.com/pls/apex/f?p=42:1909:::NO::: ), all my icons are small, for example in Hero Region:

Or in static content if I use: <div class="colorClass" style="display: inline"><span class="fa fa-home fa-4x"></div></span><div class="txtclass" style="display: inline"> Welcome</div>
The home icon will not resize, it stays small exactly as in Hero Region.
There are like 2 more issues but I will write in separate topic.
Thanks.