Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, August 9, 2012

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.


5 comments:

karthik said...

Sameer kind thanks for sharing your knowledge, the article is nice, it helps so much...

Santhu said...

Please let me know if we need to assign the role to all the users.

Joanne said...

This is a great article. Could you tell me if this can be setup to view the output for all requests submitted by application? We already have one setup by responsibility but have had a request to allow the application SME to view the requests submitted within the application.

Mohammed Merajuddin said...

Hi Sameer,

i followed the same ,but i am not able to view the requests output of other users

SATISH VEMULAPALLI said...

you can view other requests
Navigation To Search Request Id : View --> Requests --> select Specific Requests --> search with Request id --> Find