In OEBS we need that the column TERMINAL_ID of the table FND_UNSUCCESSFUL_LOGINS displays values instead of the
We are using the following query
B.USER_NAME, U.ATTEMPT_TIME, U.TERMINAL_ID FROM FND_UNSUCCESSFUL_LOGINS U,
FND_USER B WHERE U.USER_ID = B.USER_ID AND B.USER_NAME LIKE NVL(:USER_NAME, '%')
In Metalink we found that first the table
FND_UNSUCCESSFUL_LOGINS being updated, and then ( maybe with short delay ) an
entry within access_log appears, which contains : errCode=FND_APPL_LOGIN_FAILED.
To get the IP address, tie up the data from FND_UNSUCCESSFUL_LOGINS table to the access_log, verify for entries with "errCode=FND_APPL_LOGIN_FAILED", which should show the IP.
How can we get the terminal_id Column value? or How can we tie up the data from FND_UNSUCCESSFUL_LOGINS table to the access_log?