You can put inside a folder and add permission only for this role. You can set the permission at OTBI level as well. Thanks.

Do you know the count expected? It is mostly related to performance only. Thanks.

Upvoted!!! This will be a great enhancement to the product.

If you are talking from Fusion SaaS perspective, this is currently no supported. An idea is logged for same. Please evaluate and upvote: Report to get details about security roles and permissions configured for all reports - Page 2 — Oracle Analytics Thanks.

Can you please elaborate your query, so that the community members can help? Thanks.

I don't think this is possible as these details are stored as METADATA not in direct tables. What are the Tables Where the ESS Jobs and Custom Job Sets are Stored? (Doc ID 2430380.1) There is an idea already submitted for the same. Please evaluate and upvote: Required ESS Schedule Process Job Name — Cloud Customer Connect…

Upvoted the idea. This is really critical to audit who has made the updates at admin level and to what component and what was the value before change. We had a case where an SFTP server was deleted by someone by mistake, we had no option to check and find who did this.

I don't see any communication related to this from Oracle yet. Have you seen any such documentation? Thanks.

Can you join using below? wft.IDENTIFICATIONKEY = TO_CHAR(req.requisition_id) with irc_requisitions_vl view/table. Thanks.

Hi Gavin, The reports you are mentioned are related to changes happening on BIP objects - catalogs etc but not on the changes related to a particular module. If you are looking for a particular table, you need to check audit tables for that main base table (audit table have similar name but ends with an underscore). Thanks.

Hi Suprit, CustomerConnect is the right forum for such question. Please post your query on appropriate category on below forum: Sales — Cloud Customer Connect (oracle.com) Thanks.

Hi Arun, Follow the steps mentioned in below MOS note to assign permissions and clear cache: All HCM Extracts Were Erroring Out. ESS Process Shows Error java.lang.SecurityException: Security violation user: fusion_apps_hcm_ess_appid, permission: 2240 (Doc ID 2870939.1) Once done, please rerun the extract. Thanks.

Can you try below? WITH org_tree AS ( SELECT /*+ materialize / DISTINCT * FROM ( SELECT ( SELECT haoufv_p.name FROM hr_all_organization_units_f_vl haoufv_p WHERE haoufv_p.organization_id = potnv.parent_organization_id AND TRUNC(SYSDATE) BETWEEN haoufv_p.effective_start_date AND haoufv_p.effective_end_date ) parent_org_name…

I don't think there is a seeded report for this. You can create a custom one but it won't give you data for more than 7 days: User Last Login Date Report — Cloud Customer Connect (oracle.com) You can check the REST API as well: Fusion Security: Using Sign In - Sign Out Audit REST API (Doc ID 2661308.1) Thanks.

Anybody has found any workaround so far? We have started to face this issue recently because a new company addition in our environment.

Thanks for sharing. Definitely a good know feature !!! Thanks.

Hi, Can you please elaborate your query a bit more? I can see you are able to pull the Ids already. Also, check if the query on below link suffice your requirement to show org id for each row: https://fusionhcmconsulting.com/2021/12/bip-query-to-extract-department-tree/ Thanks.

This is the expected behavior as per Oracle official MOS note: Fusion BI Publisher Report Columns Missing When Exporting To CSV (Doc ID 2177002.1) Fusion BI Publisher - Output to .csv Files sometimes Switches/incorrect Column Order (Doc ID 1968541.1) Thanks.

How can I access it? Thanks.

There is an existing idea. Can you please evaluate that and vote on below idea? It helps to consolidate votes on a single idea and prioritize: BIP Reports built on Excel Template currently doesn't support Report Output Format Option as xlsx — Oracle Analytics Thanks.