Oracle Fusion AI Data Platform

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion AI Data Platform

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Internal FDI table for user-role assignment

Incorrect Answer
53
Views
2
Comments
Victor H
Victor H Rank 6 - Analytics & AI Lead
in Oracle Fusion AI Data Platform

Is there an FDI table with the details of user to licensed role mapping? (e.g. HCM Consumer)

We found dw_user_role_data_asgnmnts_d but this only shows roles related to security assignments

Tagged:

Answers

  • Sushanta Chakraborty-Oracle
    Sushanta Chakraborty-Oracle Rank 5 - Community Champion

    Recommend to check out this discussion:

    https://community.oracle.com/products/oracleanalytics/discussion/20439/how-to-export-out-the-user-to-group-mapping-that-is-configured-in-faw?utm_source=community-search&utm_medium=organic-search&utm_term=user+group+mapping

  • Victor H
    Victor H Rank 6 - Analytics & AI Lead

    Thanks Sushanta.

    So currently the only option to get this is creating a query in OTBI and then extracting that to FDI?

    Are there no FDI ADW tables that already hold this data?