Please check the query on below link: How do I pull an employee's Primary address in a data model? — Cloud Customer Connect Thanks.

Upvoted !!! this is definitely a good addition.

Currently, it is system limitation. If any of the base table attribute is not available, you can create an idea to bring it in the subject area. Only solution is to create a BIP report in this case. You can create multiple SA reports with conditions. Please check below document for details on cross subject area report…

Hi, As mentioned in my earlier post, it is not possible to extend the seeded subject area. You can't bring any additional columns from base tables into this SA. Thanks.

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.