Reset INTERNAL password in APEX 3.0

If you forget your APEX password of the INTERNAL workspace, here's what you can do:

1. Connect to your database AS SYS DBA (or a user with high privileges): sqlplus sys as sysdba
   
2. SQL> alter user FLOWS_030000 account unlock;
3. Connect to your database as FLOWS_030000: sqlplus flows_030000/password@your_db
   
4. Run following procedure from SQL>
   begin
www.flow_api.set_security_group_id (p_security_group_id => 10);
www.flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin1',
p_email_address => 'email@ae.com',
p_web_password => 'admin1');
end;
/
commit;

5. Connect again AS SYS DBA
6. SQL> alter user FLOWS_030000 account lock;

That should have fixed your problem. Try again to login into APEX.