Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Query for User Login History and Module Access

Received Response
595
Views
2
Comments

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    OTBI is extremely black-boxed and you have a lot less access to information than for a real OBI implementation.

    You would have to contact Oracle Support for this.

  • 4126724
    4126724 Rank 1 - Community Starter

    Hi Chris,

    Thank you for your replies. Will try to get Oracle support at the meantime as well.