Hello,

Following the below steps will help you unlock you account:

In the example below, we are unlocking the account named DEMO in workspace DEMO.1 - In SQL Developer Web connected as ADMIN, verify the status of the database account and the APEX repository account:

select username, account_status from dba_users where username = 'DEMO';

select workspace_name, user_name, is_admin, is_application_developer, account_locked,
       failed_access_attempts
  from apex_workspace_developers
 where user_name = 'DEMO'
 order by 1;

2 - If the user is locked in the database, unlock it using the ADMIN account:

alter user DEMO account unlock;

3 - If the user is locked in the APEX repository, connect as that user (or the workspace assigned schema) to the database and unlock it using APEX API:

• This will not work while connected as ADMIN
• This will not work while connected using SQL Developer Web

begin
    apex_util.set_workspace('DEMO');
    apex_util.unlock_account('DEMO');
    commit;
end;
/

Resource:

Regards

Rawan