Book Image

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By : Andy Penver
Book Image

Oracle E-Business Suite R12 Core Development and Extension Cookbook

By: Andy Penver

Overview of this book

Oracle's suite of applications is used by many major businesses and public sector organizations throughout the world. The book will show you how to build different types of extensions with different toolsets with Oracle E-Business Suite R12. It will take you from start to finish with fully working examples. This book will show you how to extend Oracle E-Business Suite Release 12. You will learn highly desirable skills on how to extend the application and develop your expertise. The book will provide detailed information about why things have to be done in certain ways, and will take you through the process of how to get started, what tools are needed, how to develop working examples, and how to deploy them within the application. Learn how to extend Oracle E-Business Suite (EBS) Release 12. There are detailed examples to work through, such as how various components are configured and how we can extend standard functionality. The book focuses on core development and extension and each chapter will introduce a topic before going through working examples from start to finish. There are plenty of detailed screen shots throughout each chapter giving clear instructions of what we are doing and why. Each recipe will develop a solution that will utilize core components to that topic. The Oracle E-Business Suite R12 Core Development and Extension Cookbook focuses on starting an extension right from the beginning, to deploying it within E-Business Suite. At the end of each chapter the reader will have a good understanding of what they need to do for each area to take away, and start using it in practice. Each chapter will detail how to build an extension in the supported manner and also comes with complete fully tested code, and scripts that can be downloaded.
Table of Contents (12 chapters)
Oracle E-Business Suite R12 Core Development and Extension Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

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.