@Ankur Jain--Oracle Since you are able to see Administration→ Manage session in OTBI so ideally you should have admin privileges. Sometimes it takes a while to show the corresponding OTBI query when a Data Validation run is triggered. Just wait for sometime and then refresh the browser and check the Manage session again on…

@Ankur Jain--Oracle You can compare the OTBI Session logs generated in both Test and Prod for this particular metric. In case there is no difference then there is something missing on the permissions of the user on the FA side. Also, if your security structure is same between Test and Prod then compare the User accounts…

@Ankur Jain--Oracle SEC_SECURE_BY_OBJ_MEMBER_USER is an internal table and not exposed to OAX_USER schema. This table comes into picture when some data level security is there in place for the user logging in. As requested by @Sumanth V -Oracle please open the same workbook again, enable the developer mode and check any…

@Ankur Jain--Oracle Yes, it looks like a data security issue. Please ensure, HCM View All Data Security role is assigned to this user. Refer: Data Roles https://docs.oracle.com/en/cloud/saas/analytics/24r2/fahia/chapter-subject-areas.html#GUID-C9F7CB8F-7459-4757-A1DC-67F87061E19B

Hi @Ankur Jain--Oracle Did you verify if the underlying database table DW_BUSINESS_UNIT_D_TL. BUSINESS_UNIT_NAME contains data?

Hello @KashifRaza We have a Prebuilt Analyses in FDI called “Current Inventory Balances Analysis” which provides insight on current Inventory balances, Quantity in Receiving, Inbound quantity, In-transit, and Consigned quantity. Please check if it helps.…

@Rach23 Ok got that, 1. Did you notice any differences in the logical or physical queries, especially in the where clauses? 2. Did you have an upgrade of your FDI instance scheduled over the weekend?

Hi @Rach23 Did you compare/analyze the logical and physical queries generated for the table and bar view and notice any differences?

Hi @Victor H, Another way to do this would be to use the FDI Console→Uploads feature where you can download the sample file for Data Security Assignment and then, add the below details USERNAME, SEC_OBJ_CODE,, SEC_OBJ_MEMBER_VAL and SEC_OBJ_MEMBER_NAME. Upload and Download Data Security Assignments…

@Prasad Deshpande You can try to create a direct OTBI connection from FDI's integrated OAC. Refer: OAC : How to Connect to Oracle Fusion HCM-OTBI from OAC DV Dataset with SSO (Doc ID 2607450.1)

@Vaigu_27 Another slightly longer way is to identify the Fact table being used in the Subject Area (by dragging any measure column and checking the physical query) and then checking the relationship diagram corresponding to that fact table. (This will give you only the table level information)

Hello Vyasa, As of now we do not provide any tool to migrate the existing Fusion ERP OTBI reports into FAW. OTBI and Fusion Analytics complement each other. For more details review the below Blog. https://blogs.oracle.com/analytics/post/how-otbi-and-faw-complement-each-other In FAW have numerous in built content which are…