3 Replies Latest reply on Mar 5, 2020 5:50 AM by Maaz Khan

    Scheduled Concurrent programs

    happy10319

      Hi,

      On R12.2.4 and also 11.5.10

       

      I'm looking for a query that shows schedueled concurrent programs on my system.

       

      Thanks.

        • 1. Re: Scheduled Concurrent programs
          Dmitry B.

          Hi,

           

          Please try this (R12.2):

           

            SELECT /*+   */

                   CONCURRENT_PROGRAM_ID,

                   PROGRAM_APPLICATION_ID,

                   PRINTER,

                   PROGRAM_SHORT_NAME,

                   ARGUMENT_TEXT,

                   PRINT_STYLE,

                   USER_PRINT_STYLE,

                   SAVE_OUTPUT_FLAG,

                   ROW_ID,

                   ACTUAL_COMPLETION_DATE,

                   COMPLETION_TEXT,

                   PARENT_REQUEST_ID,

                   REQUEST_TYPE,

                   FCP_PRINTER,

                   FCP_PRINT_STYLE,

                   FCP_REQUIRED_STYLE,

                   LAST_UPDATE_DATE,

                   LAST_UPDATED_BY,

                   REQUESTED_BY,

                   HAS_SUB_REQUEST,

                   IS_SUB_REQUEST,

                   UPDATE_PROTECTED,

                   QUEUE_METHOD_CODE,

                   RESPONSIBILITY_APPLICATION_ID,

                   RESPONSIBILITY_ID,

                   CONTROLLING_MANAGER,

                   LAST_UPDATE_LOGIN,

                   PRIORITY_REQUEST_ID,

                   ENABLED,

                   REQUESTED_START_DATE,

                   PHASE_CODE,

                   HOLD_FLAG,

                   STATUS_CODE,

                   REQUEST_ID,

                   PROGRAM,

                   REQUESTOR,

                   PRIORITY

              FROM FND_CONC_REQ_SUMMARY_V

             WHERE     PHASE_CODE = 'P'

                   AND STATUS_CODE IN ('I', 'Q')

                   AND ((   DECODE (IMPLICIT_CODE,

                                    'N', STATUS_CODE,

                                    'E', 'E',

                                    'W', 'G') =

                            STATUS_CODE

                         OR DECODE (IMPLICIT_CODE, 'W', 'E') = STATUS_CODE

                         OR DECODE (IMPLICIT_CODE, 'Y', STATUS_CODE) = STATUS_CODE))

                   AND (NVL (request_type, 'X') != 'S')

                 --  AND (request_date >= TRUNC (SYSDATE - 7))

          ORDER BY REQUEST_ID DESC

          • 2. Re: Scheduled Concurrent programs
            hal9000akilroy

            SELECT

            A.PROGRAM,-- || chr(9) ||

            A.PROGRAM_SHORT_NAME,-- || chr(9) ||

            A.ARGUMENT_TEXT,-- || chr(9) ||

            B.NLS_LANGUAGE,-- || chr(9) ||

            to_char(b.REQUESTED_START_DATE,'hh24:mi') hhmi,-- || chr(9) ||

            rtrim(FCR.RESUBMIT_INTERVAL)||' '||rtrim(FCR.RESUBMIT_INTERVAL_UNIT_CODE) interv1,-- || chr(9) ||

            decode(rtrim(FCR.RESUBMIT_INTERVAL)||' '||rtrim(FCR.RESUBMIT_INTERVAL_UNIT_CODE),'14 DAYS',to_char(a.REQUESTED_START_DATE,'DY'),'7 DAYS',to_char(a.REQUESTED_START_DATE,'DY')) interv2,-- || chr(9) ||

            translate(substr(sch_curr_values,33,7),'01','nY') interv3,-- || chr(9) ||

            TRANSLATE(REPLACE(REPLACE(substr(sch_curr_values,1,31),'1:',' '),'14',' '),'01YN47DSP:','nY ')interv4,-- || chr(9) ||

            translate(substr(sch_curr_values,32,1),'01','nY') interv5,-- || chr(9) ||

            A.REQUESTOR,-- || chr(9) ||

            fres.RESPONSIBILITY_NAME,-- || chr(9) ||

            TO_CHAR(a.REQUESTED_START_DATE,'YYYY/MM/DD HH24:mi:ss') next_start

            FROM FND_CONC_REQ_SUMMARY_V  A,

            FND_CONCURRENT_REQUESTS B,

            FND_CONC_REQUESTS_FORM_V FCR,

            FND_RESPONSIBILITY_VL FRES

            WHERE a.REQUEST_ID = fcr.REQUEST_ID

            AND a.REQUEST_ID = b.REQUEST_ID

            and A.PHASE_CODE = 'P'

            AND A.STATUS_CODE IN ('I', 'Q')

            and FCR.RESPONSIBILITY_ID = FRES.RESPONSIBILITY_ID

            order by 1, b.REQUESTED_START_DATE DESC;

            • 3. Re: Scheduled Concurrent programs
              Maaz Khan

              Hello Happy,

               

              Adding to the list, I use below to get details -

               

               

              select

                      fcr.request_id,

                      fcr.parent_request_id,

                      fu.user_name requestor,

                      to_char(fcr.requested_start_date, 'MON-DD-YYYY HH24:MM:SS') START_DATE,

                      fr.responsibility_key responsibility,

                      fcp.concurrent_program_name,

                      fcpt.user_concurrent_program_name,

                      decode(fcr.status_code,

                             'A', 'Waiting',

                             'B', 'Resuming',

                             'C', 'Normal',

                             'D', 'Cancelled',

                             'E', 'Error',

                             'F', 'Scheduled',

                             'G', 'Warning',

                             'H', 'On Hold',

                             'I', 'Normal',

                             'M', 'No Manager',

                             'Q', 'Standby',

                             'R', 'Normal',

                             'S', 'Suspended',

                             'T', 'Terminating',

                             'U', 'Disabled',

                             'W', 'Paused',

                             'X', 'Terminated',

                             'Z', 'Waiting') status,

                      decode(fcr.phase_code,

                             'C', 'Completed',

                             'I', 'Inactive',

                             'P', 'Pending',

                             'R', 'Running') phase,

                      fcr.completion_text

              from

                      fnd_concurrent_requests fcr,

                      fnd_concurrent_programs fcp,

                      fnd_concurrent_programs_tl fcpt,

                      fnd_user fu,

                      fnd_responsibility fr

              where

                      fcr.status_code in ('Q', 'I') and

                      fcr.hold_flag = 'N' and

                      fcr.requested_start_date > sysdate and

                      fu.user_id = fcr.requested_by and

                      fcr.concurrent_program_id = fcp.concurrent_program_id and

                      fcr.concurrent_program_id = fcpt.concurrent_program_id and

                      fcr.responsibility_id = fr.responsibility_id

              order by

                      fcr.requested_start_date,  fcr.request_id;