DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Need to determine if request set running and parameters

Threaded View

  1. #1
    Join Date
    Jul 2007
    Location
    Oklahoma City, Oklahoma
    Posts
    5

    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 (ORG_ID, SOB_ID), in my case the parameter I am interested in is the first one defined under "Program", "Define", then query executable, then select "Parameters".

    I want to programatically prevent this procedure from running with the same input criteria simultaneously.

    Has anyone done this? Help!
    Last edited by wrwelden; 07-24-2007 at 04:13 PM.

Posting Permissions

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


Click Here to Expand Forum to Full Width