DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Wednesday, April 5, 2017

EBS R12 Online user checking query

select usr.user_name,last_connect, resp.RESPONSIBILITY_NAME, function_type,fun.USER_FUNCTION_NAME --icx.* from apps.fnd_form_functions_vl fun,apps.icx_sessions icx join apps.fnd_user usr on usr.user_id=icx.user_id left join apps.fnd_responsibility_vl resp on resp.responsibility_id=icx.responsibility_id where last_connect>sysdate-nvl(apps.FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24 and disabled_flag != 'Y' and pseudo_flag = 'N' and icx.FUNCTION_ID=fun.FUNCTION_ID order by 1

No comments: