R12 View Output for Requests Submitted by other Users.
In R12 in order to view requests submitted by other users we need to create Roles and grant these roles to users.
Step by step instructions on how to implement this:
As SYSADMIN user with “Functional Developer” responsibility,
update object "Concurrent Requests".
Search for object Concurrent Requests.
Click on Concurrent Requests.
Click on Object Instance Sets tab.
Click on Create Instance Set button.
- Enter the following for predicate:
If the requirement is to view requests for a particular responsibility then use the below
select * from apps.fnd_concurrent_requests cr where
order by last_update_date desc
You can find the responsibility_id from the below query:
select * from apps.FND_RESPONSIBILITY_TL where responsibility_name like '%Interface%'
As the SYSADMIN user with “User Management”, go to Roles and Role Inheritance tab.
Create a Role
Select the object that we created before:
Then create a Grant for the Role.
Enter Name and Description for the new Grant.
For the Data Security Object enter “Concurrent Requests”.
Click Next and provide the Data Content Type of “Instance Set”.
Click Next and for Instance Set choose instance set created in step #1.
The permission Set is “Request Operations”.
Assign this role to users as needed. The users with this role will be able to see the log and
output files for the same as responsibility.
Go to SYSADMIN--> USER Management
Query the User Name you want to add the new role to.
Click on the Update icon.
Click Assign Roles button and find the new role.
Save and Apply to activate the new role.
If there are more number of users to assign the role then use the below API:
SQL> exec wf_local_synch.PropagateUserRole(p_user_name => 'USERNAME',p_role_name => 'UMX|9001A' );
PL/SQL procedure successfully completed.