Oracle Applications: The Concurrent Jobs Ran Yesterday and Failed – SQL script & Unix Shell Script

Posted by Jiltin     Tags: 10 June, 2009    1,585 views    (0) Comment

I often use this script to find the concurrent jobs ran yesterday and Failed. You can also automate the script into unix shell or some oracle alerts. SELECT fu.user_name, fcpt.USER_CONCURRENT_PROGRAM_NAME, fcpt.description, fcp.CONCURRENT_PROGRAM_NAME, fcr.REQUEST_ID, round((fcr.actual_completion_date – decode (trunc(fcr.request_date),fcr.requested_start_date,fcr.request_date,fcr.requested_start_date))*60*24) Read Full Article (Click here)...

Categories : 11i Scripts, Scripts Oracle Tags :

Simple K-shell (Linux,UNIX) program to monitor concurrent programs and provide feedback.

Posted by Jiltin     Tags: , , 19 March, 2009    4,604 views    (2) Comment

I wrote a Korn-shell (Linux,UNIX) program to monitor concurrent programs. This is tested and working well. This is a simple sample to connect through sqlplus and select the fnd tables to get the status #!/bin/ksh #************************************************************************************************** # This is the concurrent program monitor script # # In test cycles the programs failed to run or failed to be scheduled. # This will constantly monitor the programs. # It will Read Full Article (Click here)...

Categories : Oracle Applications, Scripts Oracle, Scripts Unix Tags : , ,

How to find the log file and output file of a concurrent Job id?

Posted by Jiltin     Tags: , , 9 January, 2009    398 views    (0) Comment

Here is the simple sql that gives you the log file and output file of a concurrent Job /***************** Author: Jay Substitute &1 or pass as parameter ******************/ SELECT fcr.request_id, fcr.outfile_name, fcr.logfile_name, fcr.argument_text FROM fnd_concurrent_requests fcr WHERE fcr.request_id IN ( &1); Sample SELECT fcr.request_id, fcr.outfile_name, fcr.logfile_name, fcr.argument_text FROM fnd_concurrent_requests fcr WHERE fcr.request_id IN ( 5594998 Read Full Article (Click here)...

Categories : 11i Scripts Tags : , ,