ERROR : Invalid Login Credentials ( APEX 4.0 )

Hi,

APEX 4.0

First of all this causes maybe :
1. you input incorrect password
2. you input incorrect user
3. you input incorrect workspace
4. account was lock by something

in this session i'll give solution for number 4 cause.

first thing to do is :
you must login to sql

1. sqlplus / as sysdba
2. sql > alter user APEX_040000 account unlock;
3. sql > conn  APEX_040000/password;
4. sql >

   begin
   wwv_flow_api.set_security_group_id(p_security_group_id=>10); 
   wwv_flow_fnd_user_api.create_fnd_user( 
     p_user_name => 'admin2', 
     p_email_address => 'dev@null.com',
     p_web_password => 'admin2') ; 
   end;
   /
   commit
   / 

5. sql > alter user APEX_040000 account lock;

then

login to apex_admin
http://test.test.local:7780/pls/apex/apex_admin

user :admin2
pass :admin2



maybe for first time login
it mus be reset password
then go to workspace task position in right of your screen

choose find a user.

then




choose image pencil to edit your user :
look for Account Privileges see Account Availability is must be "locked" change to "unlocked"
then try again in APEX home.

Thanks.