I can query table FND_CONCURRENT_REQUESTS to determine if a certain request step is running.
but the columns like 'argument#" do not seem to coorespond to concurrent request parameter values.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'
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!




Reply With Quote