Skip to content

Is there a way to query which Aurena/IEE pages a specific user has access to (via their roles), including the page's translated/localized name rather than just its internal ID?

Answer

You can join the user-to-role runtime data (FND_USER_ROLE_RUNTIME) with the presentation-object grant and definition tables (PRES_OBJECT_GRANT, PRES_OBJECT) on role and po_id to get each user's accessible pages per role. For a localized page description instead of the English one stored directly on PRES_OBJECT, use PRES_OBJECT_DESCRIPTION_API.GET_DESCRIPTION(po_id, language_code) rather than reading the description column directly — that function returns the translated description for the language you specify, where a translation exists.

← Browse Security and access questions