Thursday, March 20, 2014

Request Set Concurrent Programs and their average execution time

SELECT frsp.sequence,
         fcp.user_concurrent_program_name,
         fe.execution_file_name,
         (SELECT ROUND (
                    AVG ( (actual_completion_date - actual_start_date) * 1440),
                    2)
                    AVG
            FROM fnd_concurrent_Requests
           WHERE concurrent_program_id = frsp.concurrent_program_id)
            avg_time
    FROM fnd_request_set_programs frsp,
         fnd_concurrent_programs_vl fcp,
         fnd_executables fe
   WHERE request_set_id =
            (SELECT request_set_id
               FROM fnd_request_sets_tl
              WHERE UPPER (user_request_set_name) = UPPER ('GIL MV Refresh'))
         AND frsp.concurrent_program_id = fcp.concurrent_program_id
         AND fe.executable_id = fcp.executable_id
ORDER BY sequence 

Tuesday, March 11, 2014

ldt script error

make sure there is no space after "=" in an ldt script

FNDLOAD apps/apps2devq0 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XXGILOPENORDER_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME='GIL_GME_3_OPM PRODUCTION SUPE' APPLICATION_SHORT_NAME='GME'