這篇文章主要介紹了EBS R12中如何查詢(xún)EBS用戶(hù),具有一定借鑒價(jià)值,感興趣的朋友可以參考下,希望大家閱讀完這篇文章之后大有收獲,下面讓小編帶著大家一起了解一下。
創(chuàng)新互聯(lián)公司自2013年創(chuàng)立以來(lái),是專(zhuān)業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司,擁有項(xiàng)目成都網(wǎng)站制作、做網(wǎng)站、外貿(mào)營(yíng)銷(xiāo)網(wǎng)站建設(shè)網(wǎng)站策劃,項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢(mèng)想脫穎而出為使命,1280元安新做網(wǎng)站,已為上家服務(wù),為安新各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話:028-86922220--R12查詢(xún)EBS在線用戶(hù)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;
--查詢(xún)某用戶(hù)一年登錄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>';
--查詢(xún)用戶(hù)登錄次數(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中如何查詢(xún)EBS用戶(hù)”這篇文章對(duì)大家有幫助,同時(shí)也希望大家多多支持創(chuàng)新互聯(lián),關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設(shè)公司行業(yè)資訊頻道,更多相關(guān)知識(shí)等著你來(lái)學(xué)習(xí)!
網(wǎng)站名稱(chēng):EBSR12中如何查詢(xún)EBS用戶(hù)-創(chuàng)新互聯(lián)
網(wǎng)址分享:http://bm7419.com/article48/cdecep.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站制作、ChatGPT、App開(kāi)發(fā)、動(dòng)態(tài)網(wǎng)站、自適應(yīng)網(wǎng)站、網(wǎng)站導(dǎo)航
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)
猜你還喜歡下面的內(nèi)容