Unsuccessful logins for the running day.

If you have set up auditing in Oracle E-Business Suite then you can monitor the unsuccessful logins from the applsys.FND_UNSUCCESSFUL_LOGINS table.

For example, the unsuccessful logins for the running day.

SELECT B.USER_NAME, U.ATTEMPT_TIME

FROM applsys.FND_UNSUCCESSFUL_LOGINS U, applsys.FND_USER B

WHERE U.USER_ID = B.USER_ID

--AND B.USER_NAME LIKE NVL(:USER_NAME, '%')

AND TRUNC(U.ATTEMPT_TIME) > TRUNC(SYSDATE-1)

ORDER BY U.ATTEMPT_TIME;

Apps DBA Free Lance

Sukhwinder Singh