這篇文章主要介紹了EBS R12中如何查詢EBS用戶,具有一定借鑒價(jià)值,感興趣的朋友可以參考下,希望大家閱讀完這篇文章之后大有收獲,下面讓小編帶著大家一起了解一下。
創(chuàng)新互聯(lián)公司自2013年創(chuàng)立以來,是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司,擁有項(xiàng)目成都網(wǎng)站制作、做網(wǎng)站、外貿(mào)營銷網(wǎng)站建設(shè)網(wǎng)站策劃,項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢想脫穎而出為使命,1280元安新做網(wǎng)站,已為上家服務(wù),為安新各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話:028-86922220--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 FROM 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 FFT WHERE 1 = 1 AND U.USER_ID = ICX.USER_ID AND ICX.RESPONSIBILITY_APPLICATION_ID = APP.APPLICATION_ID AND FAT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID AND FAT.LANGUAGE = 'ZHS' AND FR.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID AND FR.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID AND FRT.LANGUAGE = 'ZHS' 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 AND ICX.COUNTER < ICX.LIMIT_CONNECTS;
SELECT FND.USER_NAME, ICX.RESPONSIBILITY_APPLICATION_ID, ICX.RESPONSIBILITY_ID, FRT.RESPONSIBILITY_NAME, ICX.SESSION_ID, ICX.FIRST_CONNECT, ICX.LAST_CONNECT, DECODE ( (ICX.DISABLED_FLAG), 'N', 'ACTIVE', 'Y', 'INACTIVE') STATUS FROM FND_USER FND, ICX_SESSIONS ICX, FND_RESPONSIBILITY_TL FRT WHERE FND.USER_ID = ICX.USER_ID AND ICX.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID AND ICX.DISABLED_FLAG <> 'Y' AND TRUNC (ICX.LAST_CONNECT) = TRUNC (SYSDATE) ORDER BY ICX.LAST_CONNECT;
--監(jiān)控concurrent 正在執(zhí)行的sql SELECT A.SID, A.SERIAL#, B.SQL_TEXT FROM V$SESSION A,V$SQLTEXT B WHERE A.SQL_ADDRESS = B.ADDRESS AND A.SID = :P_SID ORDER BY B.PIECE;
--查詢某用戶一年登錄EBS失敗的次數(shù): --用 apps/apps_password 登錄: SELECT COUNT (LOGIN_NAME) FROM FND_UNSUCCESSFUL_LOGINS L, FND_USER U WHERE 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 = '<username>';
--查詢用戶登錄次數(shù) SELECT 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_LOCATIONS HL, 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;
感謝你能夠認(rèn)真閱讀完這篇文章,希望小編分享的“EBS R12中如何查詢EBS用戶”這篇文章對大家有幫助,同時(shí)也希望大家多多支持創(chuàng)新互聯(lián),關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設(shè)公司行業(yè)資訊頻道,更多相關(guān)知識等著你來學(xué)習(xí)!
網(wǎng)站名稱:EBSR12中如何查詢EBS用戶-創(chuàng)新互聯(lián)
網(wǎng)址分享:http://www.muchs.cn/article48/cdecep.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站制作、ChatGPT、App開發(fā)、動態(tài)網(wǎng)站、自適應(yīng)網(wǎng)站、網(wǎng)站導(dǎo)航
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)