oracleEBSdbaSQLscripts

-查看EBS用戶的所有職責：

成都創(chuàng)新互聯(lián)公司服務項目包括西安網(wǎng)站建設、西安網(wǎng)站制作、西安網(wǎng)頁制作以及西安網(wǎng)絡營銷策劃等。多年來，我們專注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術優(yōu)勢、行業(yè)經(jīng)驗、深度合作伙伴關系等，向廣大中小型企業(yè)、政府機構等提供互聯(lián)網(wǎng)行業(yè)的解決方案，西安網(wǎng)站推廣取得了明顯的社會效益與經(jīng)濟效益。目前，我們服務的客戶以成都為中心已經(jīng)輻射到西安省份的部分城市，未來相信會繼續(xù)擴大服務區(qū)域并繼續(xù)獲得客戶的支持與信任！

SELECT frt.responsibility_name, furg.END_DATE
FROM fnd_user_resp_groups furg,
       fnd_responsibility    fr,
       fnd_responsibility_tl frt,
       fnd_user              fu
where fu.user_name = '&username'
   and fu.user_id=furg.user_id
   and furg.RESPONSIBILITY_ID = fr.responsibility_id
   and frt.responsibility_id=fr.responsibility_id
   --and furg.END_DATE is not null
order by 1

----現(xiàn)有的請求時間排序

SELECT fcr.request_id request_id,
       TRUNC(((fcr.actual_completion_date - fcr.actual_start_date) /
             (1 / 24)) * 60) exec_time,
       fcr.actual_start_date start_date,
       fcp.concurrent_program_name conc_prog,
       fcpt.user_concurrent_program_name user_conc_prog
FROM fnd_concurrent_programs    fcp,
       fnd_concurrent_programs_tl fcpt,
       fnd_concurrent_requests    fcr
WHERE TRUNC(((fcr.actual_completion_date - fcr.actual_start_date) /
             (1 / 24)) * 60) > NVL('&min', 45)
   and fcr.concurrent_program_id = fcp.concurrent_program_id
   and fcr.program_application_id = fcp.application_id
   and fcr.concurrent_program_id = fcpt.concurrent_program_id
   and fcr.program_application_id = fcpt.application_id
   and fcpt.language = USERENV('Lang')
ORDER BY TRUNC(((fcr.actual_completion_date - fcr.actual_start_date) /
                (1 / 24)) * 60) desc;

--查詢各個模塊的版本

select a.oracle_id,
       a.last_update_date,
       a.product_version,
       a.patch_level,
       decode(a.status,
              'I',
              'Installed',
              'S',
              'Shared',
              'N',
              'Not Installed',
              a.status) Status,
       a.industry,
       b.application_name,
       c.application_short_name
from fnd_product_installations a, fnd_application_tl b, fnd_application c
where a.application_id = b.application_id
   and a.application_id = c.application_id
   and b.language = 'US'
order by c.application_short_name;

--檢查定時任務

select
        fcr.request_id,
        fcr.parent_request_id,
        fu.user_name requestor,
        to_char(fcr.requested_start_date, 'MON-DD-YYYY HH24:MM:SS') START_DATE,
        fr.responsibility_key responsibility,
        fcp.concurrent_program_name,
        fcpt.user_concurrent_program_name,
        decode(fcr.status_code,
               'A', 'Waiting',
               'B', 'Resuming',
               'C', 'Normal',
               'D', 'Cancelled',
               'E', 'Error',
               'F', 'Scheduled',
               'G', 'Warning',
               'H', 'On Hold',
               'I', 'Normal',
               'M', 'No Manager',
               'Q', 'Standby',
               'R', 'Normal',
               'S', 'Suspended',
               'T', 'Terminating',
               'U', 'Disabled',
               'W', 'Paused',
               'X', 'Terminated',
               'Z', 'Waiting') status,
        decode(fcr.phase_code,
               'C', 'Completed',
               'I', 'Inactive',
               'P', 'Pending',
               'R', 'Running') phase,
        fcr.completion_text
from
        fnd_concurrent_requests fcr,
        fnd_concurrent_programs fcp,
        fnd_concurrent_programs_tl fcpt,
        fnd_user fu,
        fnd_responsibility fr
where
        fcr.status_code in ('Q', 'I') and
        fcr.hold_flag = 'N' and
        fcr.requested_start_date > sysdate and
        fu.user_id = fcr.requested_by and
        fcr.concurrent_program_id = fcp.concurrent_program_id and
        fcr.concurrent_program_id = fcpt.concurrent_program_id and
        fcr.responsibility_id = fr.responsibility_id
order by
        fcr.requested_start_date, fcr.request_id;

--查看用戶登錄情況

SELECT user_name username,
       description name,
       to_char(b.first_connect, 'MM/DD/RR HH24:MI') firstconnect,
       to_char(b.last_connect, 'MM/DD/RR HH24:MI') lastconnect
FROM apps.fnd_user a,
       (SELECT MIN(first_connect) first_connect,
               MAX(last_connect) last_connect,
               last_updated_by user_id
          FROM apps.icx_sessions
         GROUP BY last_updated_by) b
WHERE a.user_id = b.user_id
   AND last_connect > SYSDATE - 3 / 12
ORDER BY 4 DESC

名稱欄目：oracleEBSdbaSQLscripts
URL地址：http://muchs.cn/article26/ippecg.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供標簽優(yōu)化、靜態(tài)網(wǎng)站、App開發(fā)、營銷型網(wǎng)站建設、定制開發(fā)、網(wǎng)站設計公司

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容