Pending normal jobs running (oracle 11i) in oracle applications

Posted by Jiltin     10 November, 2008    231 views   

/*
Description: This script will all the pending normal jobs running (oracle 11i) in oracle applications
Backend query is always faster than front end query
Author:      Jay Gopal / Jiltin
Input:       none
*/

Download the Code

SELECT
fcr.REQUEST_ID,
fu.user_name,
fcr.PHASE_CODE,
fcr.STATUS_CODE,
(fcr.ACTUAL_COMPLETION_DATE –   fcr.ACTUAL_START_DATE) * 24 * 60 TIME_MINS,
fcpt.USER_CONCURRENT_PROGRAM_NAME,
fcp.CONCURRENT_PROGRAM_NAME,
fcr.ACTUAL_START_DATE,
fcr.ACTUAL_COMPLETION_DATE,
fcp.CONCURRENT_PROGRAM_NAME
FROM
apps.FND_CONCURRENT_REQUESTS FCR,
apps.FND_CONCURRENT_PROGRAMS FCP,
apps.FND_CONCURRENT_PROGRAMS_TL FCPT,
apps.FND_USER FU
WHERE  1=1
AND    fcr.PHASE_CODE = ‘P’  — Pending
AND    fcr.STATUS_CODE = ‘I’ — Normal
AND    fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID
AND    fcpt.CONCURRENT_PROGRAM_ID=fcp.CONCURRENT_PROGRAM_ID
AND    FCR.REQUESTED_BY = FU.USER_ID
ORDER BY fcr.request_id DESC;

[Post to Twitter]  [Post to Delicious]  [Post to Digg]    [Post to StumbleUpon] 

Categories : 11i Scripts Tags : , , , ,

Comments
February 20, 2009

Can I get oracle 11i software?
(oracle 11i software for sale)

Yes, you can get it from oracle store.
Look out at oraclestore.oracle.com, 11i CD pack, it may cost $120 appx. This comes with 90 days trial license.

Posted by Jiltin
Leave a comment

(required)

(required)