Applies to:
Oracle Application Object Library – Version: 11.5.0 to 11.5.10.2 – Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 29-MAY-2010
Goal
What tables are involved in using the system profile ‘Sign-On:Audit Level’?
Solution
There are three primary tables:
FND_LOGINS
FND_LOGIN_RESPONSIBILITIES
FND_LOGIN_RESP_FORMS
1. Least detailed level: User.
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.
2. Next level: Responsibility.
When the profile is set to Responsibility both FND_LOGINS and FND_LOGIN_RESPONSIBILITIES will be updated.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.
3. Most detailed level: Form.
When the profile is set to Form all three tables are involved.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.
FND_LOGIN_RESP_FORMS will be updated with one record for each form selected during the session.
Reference: Metalink Note 368260.1