Its the OAC that comes with FAW. How do we assign the DV Consumer / DV Content author role? Thanks Vj

can we perform the upgrade for FAW Non-PROD first and then schedule for PROD? or both will have to be done at the same time?

Thanks @Mallikarjuna Kuppauru-Oracle for the quick response. What roles will need to be assigned for the users in IDCS so that they can manage the FAW Security access. I referred the above links already and its pretty generic.

Go to a specific user's employment record and on the right side, you will see a small headphone icon and click on it.

No worries...Here you go! Please use below hint in the report and let confirm : SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency1', OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_optimizer_mjc_enabled'',''false'') OPT_PARAM(''_optimizer_cartesian_enabled'',''false'')…

looks like it is not possible. This is what I found from support. For Implementation users, the email address is directly stored in OID. it's not stored in Fusion DB. Only when you associate an employee record with that Implementation user, you will be able to fetch the email address of such users(Per_email_address).

Hi Meredith, How do you get the email of the users where there is no person id?

As Gaurav mentioned, please make sure the role user has the appropriate data access sets assigned and that should take care!

@Gaurav Bharadwaj-Oracle, thanks for the update!

Seeded folder security cannot be updated. Please refer the doc Oracle Fusion BI: Starting 19D, You Can Configure New BI Reporting Duty Roles to Hide the Factory Catalog Folders (Doc ID 2596730.1) Hope this helps! Vj

Are you using custom role or seeded role? That specific role could be having BI Author which allows them to create the OTBI report, but it depends on your folder security, if they can save it or not. In our case, we restricted the folder security so they will not be able to save the reports in the shared folder, but on…

Try the below: SELECT distinct per.person_number "Employee-Person", papfc.person_id, par.responsibility_type, par.responsibility_name, papfc.person_number, pea.EMAIL_ADDRESS, ppnfv.full_name full_name FROM (SELECT papf.person_id, papf.person_number, paam.LEGISLATION_CODE, (SELECT DISTINCT hlaf.country FROM…

Yes, we have created reports using OTBI and scheduled to run every week using agent hope this helps! Vj

Perfect!

Hi Katie, Per Oracle, this subject area (security real time) can't be used to create a cross-subject area analysis. Don't mix data from different folders within this subject area either. However, this was working for me or the last one year and Oracle admitted it as a bug and gave me a fix to apply on my report. Since it…

Please allow some time. If you've add the BI Author role and/or BI Publisher Data Model Developer to your custom role, it should work. BI Server takes some time to get refreshed. If it is more than 30 minutes, please logout, clear the cache and close all the windows and login again. Vj

Try running it for a single user and see if you are getting the results. I do have the same issue. We created a user role report using security subject area and Workforce real time subject area. They were working fine until 21D and since then the report is spinning and doesn't return any data. I have an SR with oracle and…

Please make sure that the security permissions are same between the main folder and sub folders. I think it should be in sync.

H Sean and Nathan, Thanks for your recommendations! I will try these.

yes, that is the option that we are trying. Create one Temp folder under shared with edit access so that users can share the reports.