Home / AppsDBA Scripts / How to check online FND_USERS in Oracle Apps

How to check online FND_USERS in Oracle Apps

Syed Saad Ali July 1, 2017 AppsDBA Scripts, Scripts Leave a comment 857 Views

How to check online FND_USERS in Oracle EBS R12

SELECT DISTINCT icx.session_id,
icx.user_id,
fu.user_name,
fu.description
FROM   icx_sessions icx,
fnd_user fu
WHERE  disabled_flag != ‘Y’
AND icx.pseudo_flag = ‘N’
AND ( last_connect + Decode (fnd_profile.Value (‘ICX_SESSION_TIMEOUT’),
NULL,
limit_time,
0
,
limit_time,
fnd_profile.Value (‘ICX_SESSION_TIMEOUT’)
/
60) / 24 ) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

Application Report Queries

QUERY TO CHECK LIST OF RUNNING REQUEST

Leave a Reply

Powered by OracleSolutions | Designed by
© Copyright 2024, https://oraclesolutions.pk All Rights Reserved