How to check start time of a set and order of its sub requests (stage) via SQL script?

Posted on 2008-02-12
Medium Priority
Last Modified: 2013-12-18
I have a Concurrent request set that contains several sub requests or stages. in some occasions users need to change the order of the sub requests (starting a sub request that normally starts in the middle of the set [stage 50] instead of the first sub request [stage 5]) but some times they don't reset the concurrent request set and when it runs again it starts at wrong stage and causes a lot of issues.
Therefore, I need a sql script to check the starting time of the set and starting stage/ sub request to make sure it would run currently.
Any help or advice would be appreciated,
Question by:kmsadr
  • 2
LVL 74

Expert Comment

ID: 20884151
please provide table structure and sample data with expected output from that sample data.

Author Comment

ID: 20886832
I was using FND_CONCURRENT_REQUESTS but I couldn't get any information on sub-requests under the concurrent request set yet. I'm still looking for correct table to use.
I'm not sure how can I provide the sample data. But my ideal output data will be some thing like:

Concurrent_Name is scheduled (or pending) to run at 20:30:00 with sub_request_name as its first stage.

Accepted Solution

kmsadr earned 0 total points
ID: 21016057
I found the answer to my own question:
FND_REQUEST_SETS.start_stage would have to be joined with FND_REQUEST_SET_STAGES_TL.request_set_stage_id and FND_CONCURRENT_REQUESTS


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses
Course of the Month6 days, 16 hours left to enroll

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question