Oracle Ebs 请求运行情况查询
SELECT REQ.REQUEST_ID,
FCP.USER_CONCURRENT_PROGRAM_NAME,
USR.USER_NAME,
REQ.REQUEST_DATE,
REQ.ACTUAL_START_DATE,
REQ.ACTUAL_COMPLETION_DATE,
ROUND((NVL(REQ.ACTUAL_COMPLETION_DATE, SYSDATE) - REQ.ACTUAL_START_DATE)*24*60,2) DAYS,
REQ.COMPLETION_TEXT,
REQ.ARGUMENT_TEXT,
REQ.LOGFILE_NAME,
REQ.OUTFILE_NAME
FROM APPLSYS.FND_CONCURRENT_REQUESTS REQ,
APPS.FND_CONCURRENT_PROGRAMS_VL FCP,
APPLSYS.FND_USER USR
WHERE REQ.CONCURRENT_PROGRAM_ID = FCP.CONCURRENT_PROGRAM_ID
AND REQ.REQUESTED_BY = USR.USER_ID
AND fcp.user_concurrent_program_name = 'Program Name'
--AND (req.completion_text IS NOT NULL AND req.completion_text <> '正常完成')
AND REQ.REQUEST_DATE > SYSDATE - 1
--AND REQ.REQUEST_ID = 66987088
ORDER BY REQ.REQUEST_DATE DESC
Oracle Ebs 请求运行情况查询
http://localhost:8091//archives/oracleebs%E8%AF%B7%E6%B1%82%E8%BF%90%E8%A1%8C%E6%83%85%E5%86%B5%E6%9F%A5%E8%AF%A2