Oracle Fusion AI Data Platform Forum

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

Categories

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
51
Views
2
Comments
Victor H
Victor H Rank 6 - Analytics & AI Lead
in Oracle Fusion AI Data Platform Forum

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?