Hi @Adam Cook, Please review the below documents for all HCM related DB Tables. Thanks, Praveen

Hi @User_30IGU, Please review the below KM Documents. Fusion OTBI: How To Use System Date & Auto Passing Of Dates In OTBI Report (Doc ID 2103487.1) Fusion OTBI: How To Use System Date & Formulas Based On System Date As Part Of Prompts In OTBI Analysis (Doc ID 2106283.1) Thanks, Praveen

Hi @Giulia Consoli, Can you please review the below document for data lineage for all HCM related subject areas. Thanks, Praveen

Hi @Oguri Sasirekha, Please review the below document to get the data lineage for all FIN related subject areas. Thanks, Praveen

HI @User_AUR8G , Can you please review the data lineage documents from the below. Thanks, Praveen

Hi @Dhanashri Mugal, You can go to More -- Permission on the Folders/reports and add those roles and assign the relevant permissions. Fusion Applications OBIEE : How do we manage permissions on a BI Catalog folder in order to make custom content available to end users ? (Doc ID 1943592.1) Thanks, Praveen

Hi @User_512BM, Please review the below post for Data Lineage mapping for the HCM subject areas. If there is no such column available, Then it will be an Idea you can log in Idea Labs. Thanks, Praveen

Hi @User_CUOHO, Can you please review the below documents. FA: SCM: OM: Can the Sales Order Report be Extended? (Doc ID 2561472.1) FA: SCM: OM:How To Add Field To SalesOrderReport Data Model (Doc ID 2344883.1) Thanks, Praveen

Hi @SM6, Yes, You can refer teh above document in your existing SR and request them to provide the list as we cannot work with internal team and provide the list on Customer Connect as Customer Connect is on general guidance / how to related questions and the info you are looking for might have PII info in it. Thanks,…

HI @User_OMVKM, As per the internal KM Doc ID 2954492.1, I see There is no out of the box subject area for Organizations and Sites. "Sales - CRM Customers" subject area has a number of fields related to Organization. Create a new idea in Idea Lab on Customer Connect to have this functionality considered in the future. For…

H @Naved Khan, Can you please review the below document for Data Lineage document for all the BICC PVOs. BI Cloud Connector: How to Find Information About Objects and Attributes for Extraction? (Doc ID 2506210.1)…

Hi @User_FV0MQ, User needs be assigned with teh below roles to get the data from Workforce Management - Worker Assignment Real Time Job Roles The following job roles secure access to this subject area: Human Resource Analyst Line Manager Duty Roles The following duty roles secure access to this subject area: Workforce…

Hi @Stephanie S, Please go to the "Review data lineage" section in the below document to find out the column you are looking for. If there is no such column exists in any subject areas, Then it will be an Enhancement Request / Idea that you need to create in Idea Labs. Doc 2254478.1 How To Log An Enhancement Request For…

Hi @SM6 , I guess there is no SQL to get the list of reports associated with the permissions in Fusion SaaS. But you can try creating an SR with referencing the below document for support to get the list of reports associated with the permissions. Fusion BI - How to Generate a Report of the BI Catalog Objects and…

Hi @Veronica_Nicolae, You can create a custom role and assign it to the users and add that role in to the permissions of the custom folder to manage the permission. Thanks, Praveen

Hello @maria.stanciu, Please review the below document which lists out all the available web services in Fusion BI Publisher. Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications (Doc ID 2086077.1) Thanks, Praveen

That's great Ryan. Please comment here or start a new thread if you need more info while implementing the security.

HI Shashank/Girish, Who ever has the BI Author or BI Admin roles can see the create option for OTBI. If you do not want the user to create the reports, Please give them only the BI Consumer role. Thanks, Praveen

Hi Ryan, Below is the repository where it lists what all teh roles required to access teh specific subject areas from each product. and it has all teh info regarding subject areas, roles, DB info etc. Below documents helps on how to create/assign the job/duty and data roles for users. Mapping Of Roles, Duties and…

Hi Farouq Ali, Please review the below document. Oracle Fusion BI: Starting 19D, You Can Configure New BI Reporting Duty Roles to Hide the Factory Catalog Folders (Doc ID 2596730.1) Thanks, Praveen