Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Does a general Subject Area reference exist anywhere?

Received Response
52
Views
3
Comments

I know of the existing Subject Area references which list the FAQs and roles that secure that subject area. Is there a more detailed reference that can give me instruction on how to work with these and create roles to allow access to specific data?

For instance, I'm currently stuck attempting to create a PO report using the Procurement - Procure to Pay subject area. I'm trying to pull the Ordered Amount from under the Purchase Order Measures.

Using the reference, I worked with the roles until I figured the Buyer role was the one I needed to view the data. But now I'm stuck. I'm trying to limit visibility to a user's own department (which are secured in the system as BUs), but I'm guessing I'm missing a Data Security Policy that would do that. I'm not sure how to set that up. Also, I need to nail down which specific privilege allows access to that field so I can create a custom role using only necessary privileges. I don't want every person who has to see this report to have the rights that the Buyer role gives (which are considerable).


Thank you

Answers

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics Lead

    Hi Ryan,

    Below is the repository where it lists what all teh roles required to access teh specific subject areas from each product. and it has all teh info regarding subject areas, roles, DB info etc.


    Below documents helps on how to create/assign the job/duty and data roles for users.

    Mapping Of Roles, Duties and Privileges in Fusion Applications (Doc ID 1460486.1)

    How to Assign or Revoke a Job Role In Fusion Applications ? (Doc ID 1995688.1)

    Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence in Release 12 (Doc ID 2262948.1)

    How to Assign Duty Role to Users or to Job Roles Using Security Console in Release 12 (Doc ID 2298075.1)

    Oracle Fusion BI: How to create a custom Role to control permissions on the BI Catalog objects (Doc ID 2308588.1)

    OTBI - Payroll - How to create data role to give access to the data only within OTBI (Doc ID 2712838.1)


    Thanks,

    Praveen

  • RyanPE
    RyanPE Rank 1 - Community Starter

    Thank you for that. It didn't answer my question directly, but it did give me a lot of valuable info that's relevant to what I'm looking at.

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics Lead

    That's great Ryan.

    Please comment here or start a new thread if you need more info while implementing the security.