Is there a way to see the FULL effective list of permission sets assigned to a user, including ones nested indirectly inside a directly-assigned permission set (since one permission set can itself be composed of other permission sets), rather than just the directly-assigned ones?

All FAQ questions / Security and access

Answer

Yes — either write a hierarchical query using Oracle's CONNECT BY clause to walk the full nested permission-set structure yourself, or use the framework's own pre-built view, FND_USER_ROLE_RUNTIME, which already resolves this full effective set for you. Note that this view may need the Security Cache refreshed after making relevant permission-set changes, for it to reflect the latest state.

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