Wednesday 28 March 2012

How to create Request set and how many methods to create request set and how to link the concurrent programs of the request set

Request set is used mostly for the dependent programs which need to run in the sequence order. Example is interface concurrent request.
Two methods to create the request set
1.Manual Method
2.Wizard Method
Manually Method
1. system administrator>concurrent>set


 Enter the values (for example)
 Set -- XXSATISH Weekly Report
Set Code -- XXSATISH WEEKLY REPORT
Application -- Application Object Library
Description -- XXSATISH Weekly Reports
Owner -- SATISH (You can select from the list of values)



Now click on Define Stages


Give the  Display Sequence and also the Stage (Concurrent program name) then stage code as 10. And then click on Requests button.

 Give the Seq value and program as concurrent program name.

In same way repeat the steps depending upon your requirement


 again click on Request button




once your concurrent request are done in the Define Stages then back to the main Request Set form and click on link stages

Specify the next concurrent program name in the success,warning or error places of the first concurrent program as shown below.


Then Click on Done button and how attach this request set to Request group as per your requirement and switch the responsibility to that responsibility and submit the request set.

Wizard Method
1. system administrator>concurrent>set


Click on Request Set Wizard


Select Sequentially or In Parallel depending upon your requirement and then click on Next button


When ever the request sets(Any concurrent program in the request set) goes error then it should be abort the process.
Even we can go continue process if we select the In Parallel request set in that case the concurrent programs in the request set are not dependable on one another. In Sequential concurrent programs may be dependencies.

Click Next button



Enter the values for
Set -- XXSATISH Weekly Report1

Application -- Application Object Library
Description -- XXSATISH Weekly Reports1



and click on Next button


Most we use is "As Each Request in the Set Completes" because if any concurrent programs completed then we can click on view out and we can view the output of that concurrent program if request set not completed also.
If we go for "After the Entire Set Has completed" then we are able to check all the concurrent program output when all the request of the request set is completed.
And then Click on Next button


Please enter all the concurrent programs which you want to attach to request set.



Then click on Finish button.



It will display the message that Your request set has been created and saved. click OK button.
Then query for your request set and check it.
In Wizard method Set code is generated by itself.




5 comments:

  1. Learn Oracle CLoud Applications here -->
    http://oraclecloudconcepts.blogspot.com/

    ReplyDelete
  2. Hi Sathish,

    Good info, I want how to use Pragma_Autonomous_Transaction in procedures as project side?
    Could You pls let me know with reference.........
    Thanks in advance
    by Venu

    ReplyDelete
  3. Thanks Venu.

    I will share in my blog

    ReplyDelete
  4. Can we run request set inside another request set?

    ReplyDelete
    Replies
    1. I mean, while defining a stage, can we include request set instead of concurrent programs?

      Delete