Skip to Main Content

Analytics Software

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!

Query for User Login History and Module Access

4126724Apr 8 2020 — edited Apr 8 2020

Hi,

I would like to create an OTBI report to extract the user login histories and module access information from beginning of time till the current datetime if possible. Appreciate if any of you could provide me the query or table information. Understand that from some Oracle related articles and posts, table ase_user_login_info and fnd_sessions will be get purged after sometimes, so is there any table log all these information from beginning of time till the current time?

Kindly assist. Thanks.

Comments
Post Details
Added on Apr 8 2020
2 comments
485 views