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.

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…