Execute a Concurrent Program from OAF/Self Service page



If we need to restrict the users from executing a concurrent program instead of having them go to the SRS form and select the concurrent program and enter the parameters. If a responsibility does not have access to forms but needs to run a concurrent program on a regular basis then the user can be given this option. Here are the setup steps and the SOP (Standard Operating Procedure).

Setup steps

Responsibility: System Administrator
Navigation: Application > Function                                          
Step 1: Create a new form function

Description tab:

Description: XX_RUN_REPORT
User Function Name: Run Report
Description: Run a report from Self Service page
Step 2: Properties tab

Type: SSWA jsp function
Context: Responsibility


Type: SSWA jsp function
Context: Responsibility
Step 3: Form tab

Step 4: Web HTML tab

HTML call:

OA.jsp?akRegionApplicationId=0&akRegionCode=FNDCPPROGRAMPAGE&programApplName=XXCUST&programName=XXEYARINV
&programRegion=Hide&scheduleRegion=Hide&notifyRegion=Hide&printRegion=Hide

The call is broken into 2 lines as the line did not fit into the width of this page. Both lines should be concatenated together into 1 line and entered into the form.

Save and close form.

Step 5: Check responsibility

Navigation: Security > Responsibility > Define


Note the menu name

Step 6: Check the menu attached to the responsibility

Navigation: Application > Menu
Add the function as a menu item
Prompt: Run Report <- This can be any name
Function: Run Report <= This is the user function name


Usage
Login to Oracle apps and go to the responsibility to which the function was assigned to.
You can now view the function you have created, i.e. XX Run Report.


Click on the function, XX Run Report.

Select a customer as the first parameter

Select From Date

Click on Next

Click Submit

Click OK button. You will be shown all the concurrent requests that have been run for this user. Click on the Output icon for the request to view the output.


The output will look like this:

The above configuration is used in HRMS to give the end users the option to run their own payslips. The Payslip report is executed as a concurrent request as the HRMS users normally do not have access to Oracle forms responsibilities. The setup can be used for many such requirements.