Oracle Analytics Publisher (BIP)

Products Banner

BIP Report to Get Last 30 Days User Login Details

Received Response
159
Views
5
Comments

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.

Answers

  • 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.

  • 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.

  • 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

  • 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.

  • @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).