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¬ifyRegion=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.