How to Allow a different Users to See your Output file which are having Same Responsibility

By
Advertisement


Steps to Reproduce:

 As user A using responsibility X submit and run a program Z.
After program Z has completed connect as user B using responsibility X and view the output of concurrent program Z nothing is returned.


1. As the SYSADMIN user with “Functional Developer”, update object "Concurrent Requests"
  Navigation: Sysadmin --> Functional Developer



Search for FND_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:

&TABLE_ALIAS.request_id in (select cr.request_id from fnd_concurrent_requests cr where
cr.responsibility_id = fnd_global.resp_id and cr.responsibility_application_id =
fnd_global.resp_appl_id)




2. As the SYSAMIN user with “User Management”, go to Role Categories tab


Update --> Add another row 


Enter name for a new category and apply
Under Tab Roles & Role Inheritance


3. As the SYSADMIN user with “User Management”, go to Roles and Role Inheritance tab.


3.1 Create a Role and then create a Grant for the Role. (For each responsibility that you want to modify)
Enter Name and Description for the new Grant.
Enter Category created on step 2.
Search for Application name "Application Object Library".
Save


 
3.2 Create Grant (2 new Grants)
3.2.1 Enter Name and Description for the new Grant. (Responsibility)
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.



Click Next For Instance Set Details add the following parameters
- parameter 1: Name_from_the_responsibility (i.e System Administrator)
- parameter 2: FND
For Set (Select the permission set or menu navigation set that defines the grantee's access.) use "Request Operations".
Finish



3.2.2 Enter Name and Description for the new Grant. (Request_Group)
Click on Create Grant
For the Data Security Object enter “Concurrent Programs”.



Click Next and provide the Data Content Type of “Instance Set”.
Click Next and for Instance Set choose instance set "Programs that can be accessed".



Click Next For Instance Set Details add the following parameters
- parameter 1: Name_from_the_responsibility_Request_Group (i.e System Administrator Reports)
- parameter 2: FND
For Set (Select the permission set or menu navigation set that defines the grantee's access.) use "Request Operations".
Finish





4. Assign this role to users as needed. The users with this role will be able to see the log and output files for other user in the same responsibility.
Sign in as sysadmin --> User Management Responsibility --> SubMenu User
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.



5. Run concurrent program from System Administrator
5.1 "Workflow Directory Services User/Role Validation" Parameters : 10000, Yes, Yes, Yes
NOTE: the request must be executed by using the following Navigation Menu:

6. Now run the any payables program from any user and  the above should see that program output under the same responsibility.