RSS

Tag Archives: concurrent process

EBS, How much time each run of a program takes

Here is a query that help you to  know how much time each run of a program takes, however it is for administration and performance tracing purposes.

SELECT REQUEST_ID,
TO_CHAR(REQUEST_DATE,’DD-MON-YYYY’) “Date”,
RPAD(USER_CONCURRENT_PROGRAM_NAME,60) “Program Name”,
RPAD(ARGUMENT_TEXT,20) “Arg”,
RPAD(TO_CHAR(A.ACTUAL_START_DATE, ‘hh24:mi:ss’),10) “Start”,
RPAD(TO_CHAR(A.ACTUAL_COMPLETION_DATE, ‘hh24:mi:ss’),10) “End”,
RPAD(TO_CHAR( (TRUNC(SYSDATE) + ( A.ACTUAL_COMPLETION_DATE – A.ACTUAL_START_DATE)), ‘hh24:mi:ss’),10) “Actual”,
C.USER_NAME,
STATUS_CODE “S”
FROM APPLSYS.FND_CONCURRENT_REQUESTS A, APPLSYS.FND_CONCURRENT_PROGRAMS_TL B, APPS.FND_USER C
WHERE B.USER_CONCURRENT_PROGRAM_NAME LIKE ‘Autoinvoice Import Program’ — insert program “request” to query
AND A.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
AND A.REQUEST_DATE >= ’24-sep-2012′ — insert date you need to query from
AND A.REQUESTED_BY = C.USER_ID
ORDER BY REQUEST_ID DESC;

———

Cheers

Muhammad Rashed

 
Leave a comment

Posted by on February 4, 2013 in Queries

 

Tags: , , , ,