Unlock APEX ADMIN user account without resetting password.

 Once the Apex admin user account is locked.You have only two option left.

1. Reset the admin user account  or

2. Unlock the ADMIN account

for step 2: To unlock the ADMIN account

! Query the id for the “INTERNAL” workspace:

SQL> SELECT workspace_id FROM apex_workspaces WHERE workspace = 'INTERNAL';

WORKSPACE_ID

    10

!! Find  the APEX schema’s name for your version:

SQL> select username from dba_users where username like 'APEX%' order by 1;

USERNAME

APEX

APEX_050200

APEX_PUBLIC_USER

 SQL>

!!! Switch to  your session to the APEX-schema:

SQL> alter session set current_schema = APEX_050200;                     

Session altered.

SQL>

!!!! Unlock your ADMIN account with the following code:

 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.

SQL>