FND Tables for login details

參考網址

There are three primary tables which are involved in using the system profile ‘Sign-On:Audit Level’:

1) FND_LOGINS

2) FND_LOGIN_RESPONSIBILITIES

3) FND_LOGIN_RESP_FORMS

- When the profile is set to “User”, the only table that gets updated is the table FND_LOGINS and only one record per user session

- When the profile is set to “Responsibility”, both FND_LOGINS and FND_LOGIN_RESPONSIBILITIES will be updated:

a) FND_LOGINS gets only one record per user session

b) FND_LOGIN_RESPONSIBILITIES will be updated with one record for each responsibility selected during the session

- When the profile is set to “Form” all three tables are involved:

a) FND_LOGINS gets only one record per user session

b) FND_LOGIN_RESPONSIBILITIES will be updated with one record for each responsibility selected during the session

c) FND_LOGIN_RESP_FORMS will be updated with one record for each form selected during the session

In terms of performance, the data capture has negligible overhead.