For every implementation, there would be functional consultant who looks into the security and their job is to create a security matrix with all users list and their roles mapped on to a sheet. It would be tough to create this sheet manually when there are 1000’s of employees and it doesn’t make any sense to do it manually.
In order to overcome this challenge, we can create a BI Report and use the direct database option of OTBI to create pivot table to get the users/roles in matrix format.
WHERE PU.ACTIVE_FLAG = ‘Y’
AND SYSDATE BETWEEN PU.START_DATE AND NVL(PU.END_DATE,’4712/12/31′)
AND PU.USER_ID = PUR.USER_ID
AND PRD.ROLE_ID = PUR.ROLE_ID
AND PRD.LANGUAGE = ‘US’
ORDER BY PU.USERNAME DESC
Catalog File: Security_Matrix_-_User_Roles.catalog
a) Login to the instance/Pod.
b) Navigate to Reports and Analytics
c) Click on Browse Catalog and navigate to the desired folder where you want this analytics to be imported.. Ex: My Folders or Custom Folder.
d) Click on the Unarchive button in the left bottom and select the catalog file that you downloaded from this post.
e) The analytics is imported with name “Security Matrix – User Roles” and is ready to use.
f) Click the Open hyperlink to run the analytics. The o/p can be exported using the export option at the end of the o/p (scroll till the end to see this option).
If you have any questions, please feel free to reach out to me by posting in comments section.
If you are interested in learning Fusion Technical tools go through this post
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM