Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle E-Business Suite R12 Core Development and Extension Cookbook

You're reading from   Oracle E-Business Suite R12 Core Development and Extension Cookbook Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots.

Arrow left icon
Product type Paperback
Published in May 2012
Publisher Packt
ISBN-13 9781849684842
Length 480 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Andy Penver Andy Penver
Author Profile Icon Andy Penver
Andy Penver
Arrow right icon
View More author details
Toc

Table of Contents (12) Chapters Close

Oracle E-Business Suite R12 Core Development and Extension Cookbook
Credits
About the Author
About the Reviewers
1. www.PacktPub.com
2. Preface
1. Creating Concurrent Programs 2. Oracle Forms FREE CHAPTER 3. Advanced Oracle Forms 4. Forms Personalization 5. Workflow 6. Utilities

Creating request sets


In this next recipe we are going to link the concurrent programs and run them together as a request set.

We are going to complete the following tasks in this recipe:

  • Run request set wizard

  • Add a request set to a request group

  • Run the request set

Run request set wizard

To create a request set we are going to run a wizard. The request set allows us to link concurrent programs together. Concurrent programs can be run sequentially or in parallel as a group. They can also be dependent upon the outcome of another program within the request set.

How to do it...

To create a request set using the wizard complete the following tasks:

  1. 1. Log in to Oracle with the System Administrator responsibility.

  2. 2. Navigate to Requests | Set and the Request Set window will open, as shown in the following screenshot:

  3. 3. Click the Request Set Wizard button.

  4. 4. Select the radio button called Sequentially (One After Another) and then click Next, as shown in the following screenshot:

  5. 5. Click on radio button called Continue Processing. This is what we want the request set to do if any of the programs end with a status of Error:

  6. 6. We now need to enter the details of our request set in the wizard as shown in the following table and click Next:

    Item name

    Item value

    Set

    XXHR20001

    Application

    XXHR Custom Application

    Description

    XXHR Employee By Organization

  7. 7. We now want to print the output files as each request finishes, so select As Each Request in the Set Completes and click Next as follows:

  8. 8. Now add the concurrent programs that we want to run in the request set so add the two programs we have created, XXHR First Concurrent Program and XXHR Second Concurrent Program, and click Finish as shown in the following screenshot:

  9. 9. The following message will appear; click OK:

  10. 10. The request set is then automatically created and the completed set will appear something similar to the following screenshot. We are going to first look at the Define Stages screen and the Link Stages screen to check the configuration:

  11. 11. Click on the Define Stages button to check that the concurrent programs are configured as required:

  12. 12. Check that the screen is configured as we expected and then close the Stages window to navigate back to the Request Set window.

  13. 13. Click on the Link Stages button and the Link Stages window will open as shown in the following screenshot:

How it works...

We have now created a request set using the request set wizard. We can now run the request set, and the concurrent programs will run as we have defined them in the request set.

Add a request set to a request group

We will now add our request set to the request group we have associated with the XXEBS Extending e-Business Suite responsibility.

How to do it...

To add the request set perform the following steps:

  1. 1. Log in to Oracle with the System Administrator responsibility.

  2. 2. Navigate to Security | Responsibility | Request and the Request Groups window will open.

  3. 3. Query back the XXHR Request Group request group.

  4. 4. Now we are going to add the request set we created in the Requests region. Enter data as in the following table in the Requests block:

    Type

    Name

    Application

    Set

    XXHR20001

    XXHR Custom Application

  5. 5. Click the Save button in the toolbar (or Ctrl + S) to save the record.

  6. 6. Exit the form.

How it works...

Okay so now we have added the request set to our request group. Next we are going to run the request set.

Run the request set

Now we want to run the concurrent request set.

How to do it...

To run the request set take the following steps:

  1. 1. Log in to Oracle with the XXEBS Extending e-Business Suite responsibility.

  2. 2. Navigate to Submit Requests and click the OK button as shown in the following screenshot:

  3. 3. Navigate to the Request Set field and select the XXHR20001 request set from the list of values and click OK.

  4. 4. Click on the Submit button and when prompted to submit a new request select No and the form will close down.

  5. 5. Navigate to View Requests and click on the Find button (to find all requests) and you will see the request set as shown in the following screenshot:

  6. 6. You should see that the request set we just submitted is running.

If you click the refresh button you will see the stages of the request set complete as they are executed. Once the request set has completed you will see three records in the Requests block. One for the set and one each for the concurrent programs in the request set as shown in the following screenshot:

Note

Note: Remember to click the refresh button as the page does not refresh automatically, so if you see a program still has a phase of Running you will need to click the refresh button until the phase is Completed.

How it works...

We have now run the request set and can see that we can group concurrent programs to be run together.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image