10 October, 2015

Unsuccessful Login Attempts of FND user

select count (ul.user_id)
from fnd_unsuccessful_logins ul, fnd_user u
where ul.user_id = u.user_id
and ul.attempt_time > NVL (u.last_logon_date, u.last_update_date)
and ul.user_id = u.user_id
and u.user_name = '&username'; 

No comments:

Post a Comment

OEM Agent Installation

./agentDeploy.sh AGENT_BASE_DIR=/u001/oracle/product/agent13c OMS_HOST=oem-dev.xxx.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=*****...