Logged In User Details Report

Himanshu_Kumar

Hi ,

I need to create an OTBI report to fetch details of all users who logged into Oracle CRM on a particular day. Unfortunately, I couldn't find any suitable subject area or standard report for this requirement.

Does anyone know how I can achieve this, or if there’s a specific subject area (like audit or security reports) that I should use? I’m looking for details such as:

• User Name
• Login Time
• Logout Time
• IP Address
• Session Duration

Any guidance or example queries would be highly appreciated!

Thanks in advance!

Hassan El Bouihi-Oracle

Hello Himanshu,

Please refer to this KM Note:

Security Reports in Fusion Application (Doc ID 2210883.1)

Thank you
Hassan