Table or View with User-Group mapping

Victor H

There is no way in FDI ADW to query the current user to group mapping.

Sample Use Case: Compare Usage tracking vs. Licensed Users.

If we want to identify Inactive licensed HCM users we need to use external sources for the user list (e.g. downloading the user/group mapping CSV form the security console and then manually uploading to ADW).

This requires many additional manual steps and is not synced automatically so stale data will produce misleading results.

Proposed solution: Create a view visible to OAX_USER that can be queried for current user/group/app role assignments. Similar to how the

dw_user_role_data_asgnmnts_d can be queried for individual security assignments and their corresponding data roles.

Reference:https://community.oracle.com/products/oracleanalytics/discussion/comment/66785