For more information, please refer to this announcement explaining best practices for getting answers to questions.
Require to fetch Roles and Data Access assigned to employees for BIP report in Oracle HCM
Summary: Staff List by System Role Report
Content (please ensure you mask any confidential information): Where do I find these fields - Data Access Permissions, Data Access Permissions Start date, Data Access Permission End date, System information in HCM Cloud tables?
Column Name
Employee number
First name
Last name
Role Name (Concatenation consideration)
Role Start Date
Role End Date
Data Access Permissions
Data Access Permissions Start date
Data Access Permission End date
System
Org name
Grade Name
Directorate General
Directorate
Division
Branch
Person Job Title 1
Profession
Job Family
Job Type
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):