Enhanced Oracle APEX Upgrade Process in Oracle Cloud

Easy check if an APEX upgrade is available to your database with

select APEX_INSTANCE_ADMIN.get_parameter('UPGRADE_STATUS') as UPGRADE_STATUS from dual;

If an upgrade is available, you can initiate it during the upgrade window by running:

begin
   APEX_INSTANCE_ADMIN.set_parameter('UPGRADE_STATUS', 'RUN');
end;