Pull a report of OTBI User Folder Access

Steph Hamelbeck

Summary

We need to be able to pull a report of all user access to all OTBI folders.

Content

We need to be able to pull a report of all user access to all OTBI folders.  To know who has access to HR/financial/admin folders.  For audits and prior to refreshes (since these sometimes are deleting access).

Example:

Custom Folder
User 1
User 2
User 3
	HR Folder
	User 1
	Financial Folder
	User 2
	Admin Folder
	User 3

 

Version

20A (11.13.20.01.0)

Rich Merkel

Hi Steph,

Rutgers university created an enhancement request for this same issue.

https://cloudcustomerconnect.oracle.com/posts/e5ab73293f

Would really appreciate if you could give the thumbs up on this idea to get some traction from Oracle.

Regards,

-Rich

Robert Fighiroae-Oracle

Hi Steph,

At this moment this is not possible self-service by the customers and we already have an enhancement request.

I would suggest for the time being to raise an SR with Oracle Support, maybe we can provide this information on-demand, (at least some bulk data extracted from the back-end).

I think it's better than nothing until the enhancement will get implemented.

Be sure to raise the SR with "Technology Management - Reports & Analytics" -> "Oracle Transactional Business Intelligence".

Best regards,

Robert

User_ZTN0B

We also have a similar requirement. Thanks @Rich Merkel

FusionUser1

Have oracle made any progress on this? I cannot access the ER.

Riyaz Ali-Oracle

Please try the below and see if this helps:

Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)