Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Is there a table that logs when a user last accessed a function_id from a menu / responsibility?

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.
Best Answer
-
None of the resources/objects you mention are a standard part of a generic oracle database. It appears you are asking about the resources associated with some particular application, so the answer to your question depends on that application.
Answers
-
None of the resources/objects you mention are a standard part of a generic oracle database. It appears you are asking about the resources associated with some particular application, so the answer to your question depends on that application.
-
Sorry - I had too many screens open and have posted this question onto the wrong community.