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;
