Friday, June 4, 2021

Query to fetch the User logins details in Oracle applications R12 (ICX_SESSIONS)

 

 

 

 

 

 

 

In this post, we have given the query to fetch login details of iSuppliers and employees.

Key Table:

ICX_SESSIONS

Query (iSuppliers):

SELECT hou.short_code entity, fu.user_name, pv.vendor_name, pvc.email_address, icx.first_connect, icx.last_connect, round((icx.last_connect - icx.first_connect)*24*60,2) ||' mins' duration FROM hr_operating_units hou, ap_supplier_sites_all assa, po_vendor_contacts pvc, po_vendors pv, fnd_user fu, icx_sessions icx WHERE hou.organization_id = assa.org_id AND assa.vendor_id = pvc.vendor_id AND pv.vendor_id = pvc.vendor_id AND upper(pvc.email_address) = fu.user_name AND counter < limit_connects AND icx.user_id = fu.user_id AND fu.USER_ID > 1100;

Query (Employees):

SELECT fu.user_name, papf.full_name, papf.email_address, icx.first_connect, icx.last_connect, round((icx.last_connect - icx.first_connect)*24*60,2) ||' mins' duration FROM per_all_people_f papf, fnd_user fu, icx_sessions icx WHERE papf.person_id = fu.employee_id AND sysdate between papf.effective_start_date and papf.effective_end_date AND counter < limit_connects AND icx.user_id = fu.user_id AND fu.USER_ID > 1100

1 Responses to “Query to fetch the User logins details in Oracle applications R12 (ICX_SESSIONS)”

Oracle Apps Technical Dot Com said...
April 11, 2022 at 10:05 PM

25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students

Please Check https://www.oracleappstechnical.com for details


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.