Is there a way to generate a report listing employees/users and which license type (Full vs Limited) each has been assigned?

All FAQ questions / Security and access

Answer

Yes — query FND_USER joined to FND_LICENSED_ROLE_USER on identity, selecting the role_scope column as the license type, filtered to active users: select t.identity, t.description, t2.role_scope from FND_USER t left outer join FND_LICENSED_ROLE_USER t2 on t.identity = t2.identity where t.active = 'TRUE' order by t.identity. This can be turned into a Quick Report or similar for an ongoing license-usage audit.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions