Account locked by an other user

@Ozge if you are using PL/SQL Developer, you could look at the Active sessions and kill the one that is no longer needed.

@Ozge If you are not logged in with the IFSAPP to the Database. It is normal. You can’t reach tables. To solve this, you can use the code block below.

DECLARE
	user_name_ VARCHAR2(100) := '&Username';
BEGIN
	FOR rec_ IN (SELECT * FROM ifsapp.fnd_client_logon p WHERE p.directory_id = user_name_)
	LOOP
		ifsapp.fnd_client_logon_api.remove_session(rec_.session_id);
	END LOOP;
END;

@Marcel.Ausan You are right. However, sometimes even if you kill from sessions. The session can still exist on FND_CLIENT_LOGON_TAB. So, we must remove it from this table.

Hi @Ozge,

In IFSAPP8, FND_CLIENT_LOGON does not exist. I believe the equivalent view is FND_SESSION_RUNTIME. 

Hope this helps!

Hi @Marcel.Ausan , @hhy38 and @Charith Epitawatta,

Thanks for your answers. 

The issue was solved with your answers.