Under Users and Roles, Resource role field is blank for some of the employee
Under Users and Roles, resource role field is blank for some of the employee. I'm trying to create a custom report to figure out the employee having blank resource role. However, since Resource Role is a descriptive flexfield for this db object (JTF_RS_ROLES_B) and db column (ROLE_CODE),
I tried using this one and it is getting all the roles provisioned to the employee.
Will there be a table wherein I can map this current table to get what is selected for the resource role field of an employee?