——查看EBS用户的所有职责:
选择frt.responsibility_name furg。END_DATE
,从fnd_user_resp_groups furg,
,,,,,,fnd_responsibility ,,fr,
,,,,,,fnd_responsibility_tl frt,
,,,,,,fnd_user ,,,,,,,,,,,,傅
,傅的地方。user_name=',用户名'
,,和fu.user_id=furg。user_id
,,和furg。RESPONSIBILITY_ID=fr.responsibility_id
,,和frt.responsibility_id=fr。responsibility_id
,,furg。END_DATE不是空
,订单1
- - - - -现有的请求时间排序
选择货代。request_id request_id,
,,,,,,TRUNC(((货代。actual_completion_date - fcr.actual_start_date)/
,,,,,,,,,,,,(1/24))* 60)exec_time,
,,,,,,货代。actual_start_date start_date,
,,,,,,冷冻铸造。concurrent_program_name conc_prog,
,,,,,,fcpt。user_concurrent_program_name user_conc_prog
,从fnd_concurrent_programs ,,冷冻铸造,
,,,,,,fnd_concurrent_programs_tl fcpt,
,,,,,,fnd_concurrent_requests ,,货代
, TRUNC(((货代。actual_completion_date - fcr.actual_start_date)/
,,,,,,,,,,,,(1/24))* 60)比;NVL(,分钟,45)
,,和货代。concurrent_program_id=铸造。concurrent_program_id
,,和货代。program_application_id=铸造。application_id
,,和货代。concurrent_program_id=fcpt。concurrent_program_id
,,和货代。program_application_id=fcpt。application_id
,,和fcpt。语言=USERENV (Lang)
, ORDER BY TRUNC(((货代。actual_completion_date - fcr.actual_start_date)/
,,,,,,,,,,,,,,,(1/24))* 60)desc;
——查询各个模块的版本
选择一个。oracle_id,
,,,,,,一个。last_update_date,
,,,,,,一个。product_version,
,,,,,,一个。patch_level,
,,,,,,解码(。地位,
,,,,,,,,,,,,,“我”,
,,,,,,,,,,,,,“安装”,
,,,,,,,,,,,,,“年代”,
,,,,,,,,,,,,,“共享”,
,,,,,,,,,,,,,“N”,
,,,,,,,,,,,,,“未安装”,
,,,,,,,,,,,,,a.status)状态,
,,,,,,一个。行业,
,,,,,,b。application_name,
,,,,,,c。application_short_name
,从fnd_product_installations fnd_application_tl b, c fnd_application
,一个。application_id=b。application_id
,,和一个。application_id=c。application_id
,,和b。语言='我们'
, order by c.application_short_name;
——检查定时任务
选择
,,,,,,,货代。request_id,
,,,,,,,货代。parent_request_id,
,,,,,,,傅。user_name请求者,
,,,,,,,to_char(货代。requested_start_date, MON-DD-YYYY HH24: MM: SS”) START_DATE
,,,,,,,fr.responsibility_key责任,
,,,,,,,冷冻铸造。concurrent_program_name,
,,,,,,,fcpt。user_concurrent_program_name,
,,,,,,,解码(货代。status_code,
,,,,,,,,,,,,,,“一个”,“等待”,
,,,,,,,,,,,,,,“B”,“恢复”,
,,,,,,,,,,,,,,“C”,“正常”,
,,,,,,,,,,,,,,“D”,“取消”,
,,,,,,,,,,,,,,“E”,“错误”,
,,,,,,,,,,,,,,null
