Hello @Stefano_Mazzocca I don't think we have enough details to provide a specific answer but the starting point would be FA>HCM and check the history of PersonID 2333. Does the person have more than one assignment, are they all inactive, when and how was the change made compared to the last Pipeline? Maybe if you added…

Hi @RajaGangavarapu, There are a lot of factors/circumstances that can go into this. For example, comparing assignment end date and effective end date. Were updates made after the fact and backdated or was there a P2T run. You may want to log a SR and focus on a couple individuals. Regards, John

Hello @Sawrub, Hopefully, you have SSO enabled and you have setup the sync between FDI and FA. That is the most important factor in efficiently managing user security. However, some setup remains and you would need to create job-specific Group in FDI. Users would be assigned to these groups. The Groups are made up of…

Hello @Branden Pavol , I like your "column beautification" idea. In a Sandbox, you can choose to Modify a Subject Area and rename a column. However, that would adversely affect any workbooks that depend on the column. I did log an Enhancement Request for that functionality internally. For your reference, the ER number is :…

Hi @Caroline Blanchard, Thank you for the question. The method you followed is fine. I assume you created a Data Augmentation to bring in the concatenated column you created. Then modified the logical star followed by modifying the subject area. Were the two columns you concatenated from the same table or at least from…

Hi @Molly P, I know it seems a little simplistic, but I do see one example where resetting the cache allowed all journal lines DFFs to show. The reset steps are here: Regards, John

Hi @User_47ELX, This seems to be a duplicate post so I'll respond to the same here: I just noticed you have not received any responses. This Community discusses the pre-built FDI Data Warehouse and all the other features that come with FDI. Building your own custom Data Warehouse from Fusion would be difficult and…

Hi @User_47ELX, I just noticed you have not received any responses. This Community discusses the pre-built FDI Data Warehouse and all the other features that come with FDI. Building your own custom Data Warehouse from Fusion would be difficult and time-consuming (putting it mildly). You should look into FDI starting here:…

Hello @venkata_k, Thank you for the question. There is probably more than one way to do this. Since 'all users' will use the same filter, One idea is to use the OOTB Subject Area to create a Custom Subject Area that includes your filter. Then assign users to a group that includes the appropriate duty and data roles and…

Hello @Kauan_Bohn, Thank you for the question. This is likely possible in FDI Subject Areas without having to search for a Foreign Key but it seems like your question was not intended for the warehouse side. You may want to pose this question here: Regards, John

Hello @Anders W. Langholm, I see you never received a response on this question. We would probably need to see the SQL to offer more. In general, filtering on a Description can be problematic because they vary. It looks like your "Medarbejdernummer" column and the description column are the same thing. Do you have multiple…

Hi @Anupam Chaudhari, The 'accounted' requirement is the same for many functional areas and it will not be extracted from the source until it is accounted. You could use OTBI to queries on the source side or create a customization for the same on the FDI side. Regards, John

Hello @Prasath Thank you for the question. I have not seen this exact error before but the steps to setup the approved sender are here: You can Create approved senders here: Hope that helps. Regards, John

Hi @Bhumin Kamdar, Thank you for the question. The answer is probably 'it depends'. If you are using OAC in a standalone way and EPM>PBCS is your only source, then OAC's Oracle EPM Cloud connector would likely be the best choice. If OAC is being used as a part of FDI or if you have other data sources and especially other…

Hello @Anders W. Langholm, Thank you for the question. I do see a "HCM - Workforce Core"."Citizenship"."Nationality" and "Nationality Code". Does this give you what you need? Regards, John

Hello @FDI_USER, Thanks you for the question. First, a prerequisite for Oracle Fusion ERP Analytics is to link financial categories with natural accounts. The documentation on that prerequisite is here: After confirming that, the steps to map data security assignments to users to enable data level access is here: Lastly,…

Hi @Paras Negi, Thank you for the question. To start troubleshooting this issue, you should query this same data using the two Natural Account Names and both Fiscal periods in the source using OTBI. If you see data in the source for Fiscal Period Jan-25 for the Natural Account Name ending with *100, then create a similar…

Hello @Anna-MariaP, Thank you for the question. It appears to be intended for the Fusion HCM or OTBI Community. You can access the OTBI community here: Regards, John

Hi @Raluca Balan-Oracle, To clarify a couple things from your question.. Does this user have access to the Dataset? Is this user able to add fields from the Dataset to the Workbook and return data successfully? Thanks, John

Hi @A.J., I didn't realize it when I first responded but we did have a Bug on this and it was scheduled to be fixed in the 25.R2 release. For your reference, the Bug number is: 37830535 Regards, John