Edi Yanto (何 萬 新)

How to Access Request Output of Same Responsibility in Oracle Apps R12

Posted on: September 18, 2014


When user OPERATIONS submit a request at System Administrator responsibility, this user can see the log and output files of this request. But the other user (ex: SYSADMIN) cannot do that even has the same responsibility. If we use the View All Concurrent Requests (System Administrator Mode) form, we only can see the request but not the output file of this request.

So, if we want to access the request output of the same responsibility from another user’s requests, then we need to follow the below setup steps:

1. Login as SYSADMIN with Functional Developer responsibility and update the object Concurrent Requests

1.a. Search Concurrent Requests object and click the link to update it.

CR_1

1.b. Create new Instance Set

CR_2

 

1.c. Enter Name, Code, Description and Predicate for the new instance Set.
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)
.

CR_3

 

1.d. New Instance Set successful created.

CR_4

 

2. Login as SYSADMIN with User Management responsibility and using the Roles and Role Inheritance Tab

2.a. Create Role and then create a Grant for the Role, Data Security Object choose Concurrent Requests
RRI_1

RRI_2

RRI_3

2.b. Choose the Data Context Type Instance Set and choose the Instance Set created in above step (EY – Access Request Output of Same Responsibility)

RRI_4

2.c. Choose Permission Set Request Operations

RRI_5

2.d. Role and Grant created.

RRI_6

 

3. Assign the 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.

3.a. Query the user that you want to add this new role and click Update.

UR_1

3.b. Assign the new Role and Apply to activated

UR_2

UR_3

 

4. User OPERATIONS submit request Signon Audit Users with Request ID 5831028.
User SYSADMIN will be able to find the Request ID 5831028 and the View Output and View Log buttons are Enable also.
OPR_CR

SYS_CR

But if otherwise, user OPERATIONS cannot find the Request that user SYSADMIN submitted, because the Role just grant to the user SYSADMIN.

Reference: Doc ID 804296.1

1 Response to "How to Access Request Output of Same Responsibility in Oracle Apps R12"

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,368 other followers


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications






Follow me on Twitter

Archives

September 2014
M T W T F S S
« May   Dec »
1234567
891011121314
15161718192021
22232425262728
2930  

Visitors

Categories

Blog Stats

  • 140,585 hits

Users Online

web counter

Pages

%d bloggers like this: