Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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
602
Views
2
Comments
4126724
4126724 Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

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.