BIP Report to Get Last 30 Days User Login Details

Chainsyssupport

The Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last login details for each user.

We are not able to get the historical user login details, Is there any table or any workaround to get the Period wise login details for the user.

Gianni Ceresa

You did tag "HCM" and your question seems to be more about data than about a BIP report. Is your question about Fusion HCM Analytics? If it is, it will be moved in that category.

If it's about another product, if you provide the full name we could maybe point you in the direction of the right place where to ask.

Chainsyssupport

HI Gianni,

The client requirement is to get the login session details for all the users logged in for the last 30 days in Oracle Fusion Application. Since it is related to Users sessions, hence tagged it earlier under HCM.

The FND_Sessions table and Import User Login History Ess Job both are categorized under Applications Common as in below screenshots. Please let us know if we need to add in any other tags for the above query.

Thanks,

Chainsys Support.

Abhilash K - Deloitte USI

Hi @Chainsyssupport ,

See if this helps.

 SELECT NVL (COUNT (DISTINCT fs.user_name), 0)  cnt

  FROM fnd_sessions fs, per_users pu

  WHERE   1 = 1

     AND fs.user_guid = pu.user_guid

     AND TO_CHAR (

         FROM_TZ (TO_TIMESTAMP (fs.last_connect), DBTIMEZONE)

           AT TIME ZONE 'America/New_York',

         'yyyy-MM-dd') >=

       '2020-02-28';

Warm regards,

@Abhilash K - Deloitte USI

Chainsyssupport

Hi Abhilash,

In the above query  fnd_sessions table is used, This table only holds the last 7 or 8 days record, But We need to extract last 30 days user login record.

Thanks,

Chainsys Support.

Gianni Ceresa

@Chainsyssupport ,

You should also consider posting in the most appropriate category of https://community.oracle.com/customerconnect (that forum is the one about the Fusion apps).

This forum is mostly for the analytical platforms (mostly from a technical point of view), but can't cover data question in detail as data depends on the products (like Fusion).