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

Posted by Jiltin     Tags: , , , , 10 November, 2008    1,655 views    (1) Comment

/* 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 Read Full Article (Click here)...

Categories : 11i Scripts Tags : , , , ,