R12 Unable to View Output for Requests Submitted by other Users

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 Name, Code and Description for new instance set.
  - Enter the following for predicate:

a)      While creating the object set, the requirement is to view all the conc requests run by all users including SYSADMIN then use the below query as the predicate:

select  cr.request_id

from apps.fnd_concurrent_requests cr, apps.fnd_concurrent_programs cp

where cr.concurrent_program_id = cp.concurrent_program_id

and cr.program_application_id = cp.application_id

and cp.concurrent_program_name like  '%'

b)      But if the requirement is to view the requests only for a particular program name then change the predicate to below with the correct program name:

select  cr.request_id

from apps.fnd_concurrent_requests cr, apps.fnd_concurrent_programs cp

where cr.concurrent_program_id = cp.concurrent_program_id

and cr.program_application_id = cp.application_id

and cp.concurrent_program_name =  'MY CONCURRENT PROGRAM NAME'

If the requirement is to  view requests for a particular responsibility then use the below

select * from apps.fnd_concurrent_requests cr where
cr.responsibility_application_id =20003
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”.
 

Review and save the grant:

Save and Apply.

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.

SQL> commit;

Commit complete.