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
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
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?
Hello, I'm looking for some guidance on adding Extensible Flexfields (EFFs) into FDI. I'm particularly looking to add fields from the Additional Assignment Info area (PER_ASSIGNMENT_EXTRA_INFO_M). Has anyone done this and have any guidance to share? The documentation I have found to date has not been very insightful. Thank…
Hello, Am new to FDI but learning. I know that we can access the FDI Workbook (which you normally see in Oracle Analytics - see below) from the Fusion landing page, as demo-ed by one of our consultants. However, how do we do this? I know that in Fusion Security Console, you need to add several application roles in order to…
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
I want to know how PaaS data can be brought into FDI. Ex : Some customer related information is on PaaS. I want to bring it in FDI to join it with customer data coming from oracle fusion and then build an overall report.
We noticed today that the data augmentation card isn't available for us anymore. Anyone with the same issue? Regards
