You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of users

Accepted answer
783
Views
8
Comments
edited Oct 3, 2018 1:38PM in Reporting and Analytics for HCM 8 comments

Summary

BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of users

Content

Hi, 

We have a BI report developed to track the login time of the users which is giving unexpected output in 
PRODUCTION. Please assist asap. 

Details: 
======= 
There is a 'Login Detail Report' in production which gives details of the users logged into the PRODUCTION 
and if they updated any Goal Tasks. 

Issue: 
===== 
User ran the report on 29-Sep-2018, he got 158 records retrieved(output attached). 
The report has 3 parameters: From Date, To Date, BU. 
He gave: 
From Date: 20-Sep-2018 
To Date: 29-Sep-2018

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!