Categories
- All Categories
- 104 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 58 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
User Role Usage Report

Organization Name
GE Digital
Description
Ability to run a report that lists active users , the key privileges they have access to ( key privileges that drive subscriptions ) and the number of times this privilege was accessed in a defined period ( report parameter ) and the last time it was used. This will help assess if the users have access to subscription driving privileges that they are not using or needed. This report is essential in right sizing of the existing subscriptions
Thanks
Ram
Use Case and Business Need
Business case is there are lot of users in Fusion application who have several roles assigned to them, but unfortunately they don't even use the application/roles or never login to the system. We need a way to find out when was a role last used by a particular user
More details
I created SR#3-23061716291 : Usage of Roles in Oracle Fusion and it was mentioned in the SR that I need to create an ER
Original Idea Number: cf0876a2dc
Comments
-
Please review the "User and Role Access Audit Report".
To run the User and Role Access Audit Report:
-
In the Scheduled Processes work area, click Schedule New Process.
-
Search for and select the User and Role Access Audit Report.
-
In the Process Details dialog box, set parameters and click Submit.
-
Click OK to close the confirmation message.
Please review the documentation for more details about ""User and Role Access Audit Report"0 -
-
We really need this report in order to keep up with deprovisioning and removing access based on usage.
0 -
Fusion application users who have several roles assigned to them don't use the application/roles or never login to the system so need a way to find out when was a role last used by a particular user to effectively manage subscriptions.
0 -
Seeing a log of "x role last used xx/xx/xxxx" would be very helpful for auditing purposes!
0 -
Its very important have a report in the tematic areas, We need to create Dasboards of security, But only have SQL models
Please your help
Sidney
0 -
Having a standard Oracle OTBI report or Analysis that can list service AND privileges last used by a user is very important to ensure comapanies are properly licensed. Oracle determines usage by querying the priviledges a user has access to irrespective of the user's actual usage.
The OTBI report to run is UserNamesByServiceDetails. Your first need to run the scheduled program "Import User and Role Application Security Data".
Once above program is run, run the report and pivot this report output to count distinct users by service and by Privilege. This should match to the usage report Oracle uses to audit your company's license usage.
SKU to privilege metrick is li sted below:
1 -
We have seen this need with all Cloud implementations. Oracle needs to have some way to report out what is actual license usage by user instead of having a report based on what role/privilege is assigned to the user. This can prove to be an effective way for organizations to optimize the licensing cost over a period of time
0 -
Requirement for a report detailing active users, their key privileges, usage frequency, and last access time is common among our customers for optimizing subscriptions, pls. provide this capability.
0 -
please let me know whether we got any update on this thread . Our business team want to know exactly how many users not used their roles assigned even though they have fusion access . Is there any logic to develop a Bi report ?
Example Scenario :
Expense roles assigned to users and they not used to claim their expenses but paying oracle licenses for user roles
0