Thanks Dimple. I have gone through the documentation and only CRM/ERP/SCM are supported and HCM is not supported. But again, it doesn't help on adding a new column in existing SA instead of creating a completely custom SA. Thanks.

Thanks Dimple. But can you share a document which shows step by step guide to create a custom subject area in Fusion SaaS.? Thanks.

If you are talking about Fusion SaaS subject areas, you can't really add any new columns in that. Oracle delivers the columns in a subject area. Only possibility is to have DFF attributes. Once you create a DFF, you can run a process and it will appear in subject area. Thanks.

Can you please elaborate your requirement? Thanks.

Okay, so if you are talking about data access with in an OTBI, it would work for the mentioned roles only. You will need to customize Project Finance role in order to get data access. Project Costing Transaction Analysis Duty Thanks.

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.