EBS Customizations (MOSC)

MOSC Banner

Is there an R12 table that stores when a user last accessed a function from a menu / responsibility?

edited Jan 21, 2022 5:25PM in EBS Customizations (MOSC) 3 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center