FND_UNSUCCESSFUL_LOGINS terminal_id

5 pts.
Tags:
OEBS
In OEBS we need that the column TERMINAL_ID of the table FND_UNSUCCESSFUL_LOGINS displays values instead of the character “?” We are using the following query
SELECT
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?


Software/Hardware used:
OEBS
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: