Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a table that logs when a user last accessed a function_id from a menu / responsibility?

Gavin 42Jan 21 2022

We would like to write a report that shows when a user last accessed functions that hang off menus linked to certain responsibilities. Is this data stored in any tables in R12 anywhere?
I can see that FND_LOGINS shows logins and FND_LOGIN_RESPONSIBILITIES shows responsibilities accessed for those logins, but I can only find another table FND_LOGIN_RESP_FORMS which only shows Oracle Forms that have been accessed, not OAF based screens.
I've also found ICX_SESSIONS that appears to have one row per login session that is updated with responsibility and function_id as the user navigates through the system but doesn't log all those entries, it just overwrites the same row. I thought ICX_TRANSACTIONS might give us what we need but some rows added for that user session navigation sometimes don't include the responsibility and function_id for some reason, so cannot be relied on for the reporting requirement.
Thanks.

This post has been answered by EdStevens on Jan 21 2022
Jump to Answer
Comments
Post Details
Added on Jan 21 2022
2 comments
2,638 views