如何在EBS R12中查询EBS用户

分类：编程技术时间：2024-02-20 15:55 浏览：0 评论：0

本文主要介绍EBS R12中如何查询EBS用户，具有一定的参考价值。有兴趣的朋友可以参考一下。希望您读完这篇文章后能有所收获。让小编带你一起来了解一下吧。

--R12查询EBS在线用户SQL SELECT U.USER_NAME, APP.APPLICATION_SHORT_NAME, FAT.APPLICATION_NAME, FR.RESPONSIBILITY_KEY, FRT.RESPONSIBILITY_NAME, FFF.FUNCTION_NAME, FFT.USER_FUNCTION_NAME, ICX.FUNCTION_TYPE, ICX 。 FIRST_CONNECT、ICX.LAST_CONNECT 来自 ICX_SESSIONS ICX、FND_USER U、FND_APPLICATION APP、FND_APPLICATION_TL FAT、FND_RESPONSIBILITY FR、FND_RESPONSIBILITY_TL FRT、FND_FORM_FUNCTIONS FFF、FND_FORM_FUNCTIONS_TL FFTWHERE 1 = 1 并且 U.USER_ID = I CX.USER_ID 和 ICX.RESPONS IBILITY_APPLICATION_ID = APP.APPLICATION_ID AND FAT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID 和 FAT.LANGUAGE = 'ZHS' 和 FR.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID 和 FR.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID 和 FRT.LANGUAGE = 'ZHS' &n公共服务提供商； AND FRT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID AND FRT.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID AND FFF.FUNCTION_ID = ICX.FUNCTION_ID AND FFT.FUNCTION_ID = ICX.FUNCTION_ID AND ICX.DISABLED_FLAG != 'Y' AND ICX.PSEUDO_FLAG = 'N ' AND ( ICX.LAST_CONNECT + DECODE (FND_PROFILE.VALUE ('ICX_SESSION_TIMEOUT'), NULL, ICX.LIMIT_TIME,0, icx.limit_time, fnd_profile.value ('icx_session_timeout')/60)/24)> sysdate 和 icx.Counter < icx.limit_connector；

选择FND。 User_name, icx.Responsibility_application_id, icx.Responsibility_id ,        FRT.RESPONSIBILITY_NAME,        ICX.SESSION_ID,CT, ICX.LAST_CONNECT, DECODE ((ICX.DISABLED_FLAG), 'N', 'ACTIVE', 'Y', 'INACTIVE') 状态来自fnd_user fnd，icx_sessions icx，fnd_responsibilitibil_tl frt with fnd.user_id = icx.user_id and icx .Responsibility_id = frt.responsibility_id and icx.disabled_flag_flag_flag_flag_flag_flag <> ;

--监控并发执行sql SELECTA .SID、A.SERIAL#、B.SQL_TEXT FROM V$SESSION A、V$SQLTEXT B WHERE A.SQL_ADDRESS = B.ADDRESS AND A.SID = :P_SIDORDER BY B.PIECE;

- -查询用户一年内登录EBS失败的次数:--使用apps/apps_password登录: SELECT COUNT (LOGIN_NAME) FROM FND_UNSUCCESSFUL_LOGINS L, FND_USER UWHERE L.USER_ID = U.CUSTOMER_ID AND ATTEMPT_TIME > (SELECT MAX (START_TIME) FROM FND_LOGINS L WHERE L.USER_ID = U.USER_ID) AND ( ATTEMPT_TIME + 265) > SYSDATE AND U.USER_NAME = '';

--查询用户登录次数选择 PEO.PERSON_ID、PEO.FULL_NAME、FU.USER_ID、FU.USER_NAME、HL.LOCATION _CODE、HL.DESCRIPTION、COUNT(FL.USER_ID) AS LOGIN_TIMES FROM FND_USER FU、PER_ALL_PEOPLE_F PEO、PER_ALL_ASSIGNMENTS_F ASS、HR_locationsp； FND_LOGINS FL WHERE FU.EMPLOYEE_ID = PEO.PERSON_ID AND ASS.PERSON_ID = PEO.PERSON_ID AND ASS.LOCATION_ID = HL.LOCATION_ID AND FL.USER_ID(+) = FU.USER_ID AND FU.USER_NAME = :USER_NAME GROUP BY PEO。 PERSON_ID、PEO.FULL_NAME、FU.USER_ID、FU.USER_NAME、HL.LOCATION_CODE、HL.DESCRIPTION；

感谢您仔细阅读本文。希望小编能分享一下。这篇文章《EBS R12中如何查询EBS用户》对大家有帮助。同时希望大家支持我，关注行业信息频道。更多相关知识等待您学习！

ebs