You can find the lock accounts from the following query.
SELECT * FROM APEX_050000.WWV_FLOW_FND_USER A WHERE ACCOUNT_LOCKED = 'Y';
So, in order to unlock the admin user. Login with SYS and execute the following PL/SQL block.
BEGIN APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10); APEX_UTIL.UNLOCK_ACCOUNT(P_USER_NAME => 'ADMIN'); COMMIT; END;
I hope this will help you 🙂