Get unsuccessful users login Oracle EBS R12

SELECT *
FROM 
fnd_unsuccessful_logins a where a.user_id =0 
and trunc(a.attempt_time) = trunc(sysdate)
;