How to unlock user accounts in Oracle APEX

Many times user APEX Work-space accounts gets locked on few wrong attempts or any other reasons.

Solution:-

[oracle@ebstest apex]$ sqlplus / as sysdba

SQL> declare

  2    n_security_group apex_workspaces.WORKSPACE_ID%type;

  3  begin

  4    SELECT workspace_id

    INTO n_security_group

    FROM apex_workspaces

   WHERE workspace = 'workspace';

  wwv_flow_api.set_security_group_id(n_security_group);

 10    APEX_UTIL.UNLOCK_ACCOUNT (p_user_name => 'Username');

 11    commit;

 12  end;

 13  /

PL/SQL procedure successfully completed.

SQL>