Creating multiple concurrent programs

It is quite common to have a requirement where we need to configure a concurrent program that is similar to an existing concurrent program. To prevent us having to configure the concurrent program from the beginning, Oracle has created a button that allows us to copy an existing concurrent program. In the next recipe, we are going to create a new concurrent program that is based upon the program we have already created.

The tasks we need to perform to achieve this are the following:

• Copy an existing concurrent program

• Add a concurrent program to a request set

Copy an existing concurrent program

We are going to copy the existing concurrent program and use the same parameters. We are also going to change the default parameter for the Organization parameter so that it defaults to 'Vision Operations'.

How to do it...

To copy an existing concurrent program definition, do the following:

1. 1. Log in to Oracle with the Application Developer responsibility.

2. 2. Navigate to Concurrent | Program and the Concurrent Programs window will open.

3. 3. Press the F11 key to enter a query.

4. 4. Type in XXHR First% into the Program field and press the Ctrl + F11 keys to execute the query.

5. 5. The concurrent program we created in an earlier recipe will be returned.

6. 6. Now click on the Copy to button and the Copy to window will open, as shown in the following screenshot:

   

7. 7. Enter the data as shown in the following table:

   Item name	Item value
   Program	XXHR Second Concurrent Program
   Short Name	XXHR_SECOND_CONC_PROG
   Application	XXHR Custom Application
   Include Incompatible Programs
   Include Parameters

8. 8. Click the OK button and the window will close and you will be returned to the Concurrent Programs window. You will notice that the concurrent program is now the new one we have just copied to, XXHR Second Concurrent Program.

9. 9. Now click on the Parameters button and the Concurrent Program Parameters window will open.

10. 10. Navigate to the parameter P_ORG_ID.

11. 11. Change the select statement in the 'Default Value' field to the following:

    SELECT organization_id
    FROM hr_all_organization_units
    WHERE UPPER(NAME) = 'VISION OPERATIONS'
    

    Note

    This query assumes that you are using a Vision instance. Modify the organization name in the query if you are using a different development environment.

12. 12. Click the Save button to commit the changes.

How it works...

We have now made a copy of an existing concurrent program. We can then amend the details as required to suite our requirements.

Add a concurrent program to a request set

We are now going to add our concurrent program to our request set, so that it will be available from our responsibility when we run a new request.

How to do it...

To add the second concurrent program to our request group, perform the following:

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 second concurrent program we created in the Requests region. Enter data as in the following table for the detail records:

   Type	Name	Application
   Program	XXHR Second Concurrent Program	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...

We have now added our second concurrent program to our request set assigned to the XXEBS Extending e-Business Suite responsibility.