Scribd Logo
Upload

Welcome to Scribd!

  • 723 views

    Oracle - R12 View Concurrent Request Output by Others

    Uploaded by

    ThatERPGuy
    1. In Oracle E-Business Suite R12, the "Concurrent: Report Access Level" profile option no longer controls access to view outputs of other users' concurrent requests. 2. Role Based Access Control (RBAC) must be used instead, where an administrator creates an instance set, grant, and role to allow users to view outputs of requests submitted by other users within the same responsibility. 3. The document provides detailed steps for an administrator to configure RBAC including creating an instance set using a predicate, grant, and assigning the role to users.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Oracle - R12 View Concurrent Request Output by Others

    Uploaded by

    ThatERPGuy
    723 views6 pages
    1. In Oracle E-Business Suite R12, the "Concurrent: Report Access Level" profile option no longer controls access to view outputs of other users' concurrent requests. 2. Role Based Access Control (RBAC) must be used instead, where an administrator creates an instance set, grant, and role to allow users to view outputs of requests submitted by other users within the same responsibility. 3. The document provides detailed steps for an administrator to configure RBAC including creating an instance set using a predicate, grant, and assigning the role to users.

    Original Description:

    Oracle_R12 View Concurrent Request Output by Others

    Original Title

    Oracle_R12 View Concurrent Request Output by Others

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. In Oracle E-Business Suite R12, the "Concurrent: Report Access Level" profile option no longer controls access to view outputs of other users' concurrent requests. 2. Role Based Access Control (RBAC) must be used instead, where an administrator creates an instance set, grant, and role to allow users to view outputs of requests submitted by other users within the same responsibility. 3. The document provides detailed steps for an administrator to configure RBAC including creating an instance set using a predicate, grant, and assigning the role to users.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    723 views6 pages

    Oracle - R12 View Concurrent Request Output by Others

    Uploaded by

    ThatERPGuy
    1. In Oracle E-Business Suite R12, the "Concurrent: Report Access Level" profile option no longer controls access to view outputs of other users' concurrent requests. 2. Role Based Access Control (RBAC) must be used instead, where an administrator creates an instance set, grant, and role to allow users to view outputs of requests submitted by other users within the same responsibility. 3. The document provides detailed steps for an administrator to configure RBAC including creating an instance set using a predicate, grant, and assigning the role to users.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 6

    View Concurrent Request Output submitted by other Users

    R11

    System Administrator  Profile  System

    Search for profile  'Concurrent: Report Access Level'

    Level Value Result


    Site User The user can only view the
    requests submitted by him
    Responsibility Responsibility That user can also review the
    log and report output files from
    all requests submitted from the
    current responsibility
    User Responsibility Any user of that responsibility
    can also view the log and report
    output files from all requests
    submitted by any other user of
    that responsibility

    R12

    Unfortunately in R12 profile 'Concurrent: Report Access Level' does not work, it is a bit more complex
    process to achieve this

    In R12 this was replaced by Role Based Access Control. The UMX Role Based Access Control (RBAC) is to
    control who can view request output files.

    Note :- DBA with SYSADMIN user access should login.

    Functional Developer -> Core Services --> Create Object

    >> Search for 'Concurrent Requests'


    Click on 'Concurrent Requests' and then on tab 'Object Instance Set'

    Click Create Instance Set

    Give Name- WVU View Requests by Other Users, Code – WVU_VIEW_REQUEST, Description – WVU
    View Requests by other Users from the same responsibility

    For Predicate
    Enter below code
    &TABLE_ALIAS.request_id in(
    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)

    'Apply' it and it will give the Confirmation with Code you have entered.

    >>> Now login as a SYSADMIN User.


    Go to User Management > Role & Role Inheritance
    Click on 'Create Role'

    Category – Miscellaneous / Application – Application Object Library

    Role Code - UMX_WVU_VIEW_REQUEST

    Display Name - WVU View Requests to Other Users, Description - WVU View Requests submitted by Other
    Users
    'Apply'

    Click on 'Create Grant'

    Provide Name – WVU View Request Grant, Description – WVU View Request Grant
    Data Security -> Object -> 'Concurrent Requests'
    Click on 'Next'
    Data Context Type -> 'Instance Set'
    Instance Set -> WVU View Requests by Other Users

    Click 'Next'
    Set -> Set -> 'Request Operations'

    Click on 'Next' -> Preview and then 'Finish'

    It should give you the message for successful creation of Grant.

    Known Issue
    Sometimes it will give below Error. Just try 3-4 times, it should be fine.

    Sorry didn't dig much into it to find the exact reason behind it.

    Error Page
    You have encountered an unexpected error. Please contact the System Administrator for assistance.

    Goto 'User tab

    Search for the user you want to assign the grant.

    Click 'Update'

    Click 'Assign Role'


    Search for Role you have created above ‘WVU View Requests to Other Users’ (Code -
    UMX_WVU_VIEW_REQUEST)
    Give Justification
    You can put active date from past to view previous requests outputs.
    DONE... :)

    * Now assigned user can see the output of other user's request from the responsibility from which that
    request had been launched.

    >> You can also use the below script to assign the grant to a user.

    begin
    wf_local_synch.PropagateUserRole(p_user_name => 'USERNAME'
    ,p_role_name => ‘UMX_WVU_VIEW_REQUEST ');
    commit;
    End;

    You might also like