Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Ability to allow Non-BI Admin Users to view History of BI Reports submitted by Other Users

Submitted
51
Views
5
Comments
Sreenadh
Sreenadh Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

TTX Company

Description

We have a requirement where a specific group of users should be granted access to a set of BI reports and the users should be able to view history of these reports including the runs submitted by other users.

Using Custom Role/Permissions at BI Catalog we are able to control access to the reports, but without BI Administrator role users are not able to view history of runs submitted by other users. 

Use Case and Business Need

We have a group of payroll users who should be granted access to a specific set of Payroll BI reports and the users should be able to view complete history of these reports including the runs submitted by other users. 

Users are not even able to view History of reports related to the HCM Extracts invoked from their individual user accounts. This seems because of the standard user 'fusion_apps_hcm_ess_appid', which is being used to invoke BI Report from the HCM Extracts. 

BI Report History is being used by the payroll users to re-send or validate the Integration output on adhoc basis before sending to downstream systems/external vendors and to resend the files in case of any failures.

More details

Reference SR:

SR 3-22086386521 : Non-Admin Users not able to view BI Reports History

Original Idea Number: acaf7c5f85

Tagged:
2
Up
2 votes

Submitted · Last Updated

Comments

  • Sudhesh Nayak
    Sudhesh Nayak Rank 3 - Community Apprentice

    Can you not expose the report history via an audit report?

  • Sreenadh
    Sreenadh Rank 1 - Community Starter

    No, exposing history through report won't work as users need to access the output files against the job history to resend the files & to validate the output.

  • User_CRASE
    User_CRASE Rank 1 - Community Starter

    Can the user should have the ability to change the scope to All histories without BI admin role?

  • Ahmed Maher K.
    Ahmed Maher K. Rank 6 - Analytics Lead

    Needed Idea.

  • Andrew_Thai
    Andrew_Thai Rank 1 - Community Starter

    University of California San Diego also needs similarly functionality. We have service accounts that import large amounts of data through API's with the Import Costs and Import Payables Invoices jobs. Our users don't have access to these accounts, so when these jobs hit errors, our users are unable to open the report outputs because ownership is with the service accounts.

    It is an enormous controls and risk issue to grant users BI Administrator just to view these report outputs, and it's not feasible for our existing administrators to constantly pull these reports for users on a daily basis.