Unlock an Oracle APEX admin user (when apxchpwd.sql doesn't work)

1. Find the userId.

select user_id from APEX_240100.WWV_FLOW_FND_USER where user_name = 'ADMIN' order by last_update_date desc;

2. Set a new password.

update APEX_240100.WWV_FLOW_FND_USER

set web_password = 'Barishal2024#'

where user_name = 'ADMIN'

and user_id = 1496521242332280;

commit;

3. Unlock the Admin account.

alter session set current_schema = APEX_240100;

begin

wwv_flow_security.g_security_group_id := 10;

wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');

commit;

end;