Is there an R12 table that stores when a user last accessed a function from a menu / responsibility?
Hi. We need to write a report that can show when a user last accessed functions belonging to menus for a set of responsibilities. We are on eBusiness version R12.2.9
Are there any tables in Oracle eBusiness R12 that give this information?
I've found FND_LOGINS that shows user logins, and FND_LOGIN_RESPONSIBILITIES that shows the responsibilities accessed by the user, but another related table FND_LOGIN_RESP_FORMS only shows Oracle Forms screen accessed by the user, not OAF based screens.
I looked at ICX_SESSIONS in which the same row is updated for the user's login session navigation, so isn't logging each function accessed separately. I then looked at ICX_TRANSACTIONS which appears to be storing a row for each navigation step the user performs during their login session, but it doesn't always store the function_id (sometimes it does, other times it doesn't for some reason) so can't be relied upon for this reporting requirement.