Apex Admin account locked

SQL> SELECT workspace_id FROM apex_workspaces WHERE workspace = ‘INTERNAL’;

WORKSPACE_ID
————
10

Tested to unlock “admin” user on “INTERNAL” workspace.

SQL> alter session set current_schema = APEX_040200;

Session altered.

SQL> begin
wwv_flow_security.g_security_group_id := 10;
wwv_flow_fnd_user_api.UNLOCK_ACCOUNT(‘ADMIN’);
commit;
end;
/
PL/SQL procedure successfully completed.

Then run the apxchpwd.sql script to reset the password to login