Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122

    Unanswered: Need to determine if request set running and parameters

    I can query table FND_CONCURRENT_REQUESTS to determine if a certain request step is running.

    Code:
    select description, status_code, number_of_arguments, argument1, argument2, argument3, argument4
    from FND_CONCURRENT_REQUESTS
    where description =  'XYZ_YEAR_END_GL_VERIFY (30)' 
     and status_code != 'C'
    but the columns like 'argument#" do not seem to coorespond to concurrent request parameter values.

    I need to be able to determine if a certain concurrent request is running and the value of certain input parameters.

    Has anyone done this? Help!

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    Sounds like a custom application to me.
    ---=cf

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    It is the Oracle applications concurrent manager tables.


    If you want to gather information on how to interpret the table, use "FND_CONCURRENT_REQUESTS" in Google and 1800 responses come out with loads of information and helpful scripts. Try it out.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122
    loads , yes. helpful, in theory only, at this point in time.
    Last edited by wrwelden; 07-25-07 at 09:11.

  5. #5
    Join Date
    Oct 2004
    Location
    Oklahoma City OK -
    Posts
    122

    This might be helpful to someone as a starting point

    This might be helpful to someone as a starting point although we built a custom table to capture run_history and ensure the same request set is not submitted for execution with the same input parameters.

    Code:
    SELECT   /*+ ORDERED */
             reqs.request_id, reqs.requested_start_date requested_start_date,
             reqs.phase_code,
             DECODE (reqs.phase_code,
                     'P', 'PENDING',
                     'R', 'RUNNING',
                     'C', 'COMPLETED',
                     reqs.phase_code
                    ) phase_code_txt,
             reqs.status_code,
             DECODE (reqs.status_code,
                     'D', 'CANCELLED',
                     'Q', 'SCHEDULED',
                     'I', 'SCHEDULED',
                     'R', 'RUNNING',
                     'X', 'TERMINATED',
                     'E', 'ERROR',
                     'C', 'COMPLETED NORMAL',
                     reqs.status_code
                    ) status_code_txt,
             reqs.hold_flag, reqs.cancel_or_hold, usr.user_name,
             prg.user_concurrent_program_name prg_name, argument_text args,
             SUBSTR (argument_text, 1, INSTR (argument_text, ',') - 1) arg1
        FROM apps.fnd_user usr,
             apps.fnd_concurrent_requests reqs,
             apps.fnd_concurrent_programs_tl prg
       WHERE reqs.phase_code IN ('P', 'R')
    -- and   reqs.request_id = 20234093
         AND reqs.concurrent_program_id = prg.concurrent_program_id
         AND prg.user_concurrent_program_name LIKE
                                               '%'
                                                  --'%XYZ_PRE_CLOSING_GL_EXTRACT%'
         AND reqs.requested_by = usr.user_id
    ORDER BY DECODE (reqs.phase_code, 'R', 1, 2),
             reqs.requested_start_date,
             usr.user_name;
    Last edited by wrwelden; 07-26-07 at 13:39.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •