Hello @Vigneshvaran KJ There is no such query available for the Customers to run in order to get the list of custom and OOTB reports in FDI. You can file an idea labs request for this feature to be considered along with Business justification.

Hi @Emily Cikovsky-Oracle Since the query is on the Fusion side. Can you help move this to ?

@Victor H Can you please check the REQ_BU_ID column of the Fusion table, POR_REQ_BU_OPTIONS_ALL and verify once?

@Dhaval Parikh Stantec Can you refer , generate a HAR file for your attempt from the dashboard and check where the initial delay/lag is? Also check if the delay is consistent across different browsers?

@Dhaval Parikh Stantec Does the workbook open without any delay when opened directly from catalog and only has a delay when you try to open it from the Embedded Dashboard? If this is the case, did you perform a comparison between the HAR files for both the attempts and notice anything?

@Ruben97 Basically the subject area HCM - Performance Management has its anchoring date tied to the attribute Performance Document End Date. The assignment information of the workers are rendered based on this date. Hence the suggestion is to use filter of Performance document name instead of using Year filter. However,…

Hi @Indra Sardana-Oracle In situations where the Fusion BIP report cannot be created in FDI similar to Fusion BIP due to absence of corresponding PVO’s or due to absence of the required FDI OOTB objects which would help create a similar report in FDI. It is advisable to configure the BIP connector and get the required…

@Quinn Thacker I used the Fiscal Year from Fiscal Calendar Hierarchy and it works well for me. Can you refer my screenshot and try this?

@Quinn Thacker Please try to use Fiscal Year from Fiscal Calendar Hierarchy and let me know if it helps. Refer: OAC: Ago Function In DV Fails With nQSError: 27037 "Unresolved level" (Doc ID 2585569.1)

@ShyamKumarTech06 As pointed out by @Sumanth V -Oracle this works as expected and looks like a environment specific ADW Connector issue . I would advise you to log a SR for this and have this further investigated.

@ShyamKumarTech06 Please do not duplicate posts. We are already working on the below thread for this issue. Please close this thread and continue working on the earlier thread created,

@ShyamKumarTech06 I understand you are not creating a connection to this ADW not via OAC→Connections but via FDI Connector. But are you able to establish a connection to the same ADW using FDI's integrated OAC Connection? If, no and the same error is observed then please follow @Sumanth V -Oracle's advise and check on…

This looks like a duplicate of the below Idea which has been closed. Data Model for Fusion Analytics Warehouse Compared to Oracle Fusion Cloud Applications The data model for Fusion Analytics Warehouse is the supported interface, as described in this reference guide. Oracle manages and maintains the internals of…

Hi @Vasanthakumar Ravi, This is a known issue in the FDI/NSAW integrated OAC instances. A one off patch is available for this issue. Please raise a SR with FDI/NSAW Support team. We will involve our internal teams and have your instance patched with the fix.

@Indra Sardana-Oracle In case you do not have any follow up questions on this. Can you kindly mark the previous post as answered so that it benefits the other members in the community as well?

@Mahmoud Ashraf I mean what is the application you are using here? ie. Fusion Applications, OTBI, FDI etc

@Indra Sardana-Oracle You can manage your Data refresh schedule for SFTP related Augmentations from Data Configuration→SFTP→Pipeline Settings.

@Mahmoud Ashraf Can you please let us know the product you are using here so that we can have this query posted in the right forum?

Hi @Indra Sardana-Oracle Yes, You can schedule the data augmentation pipeline for SFTP connection separately. Just keep in mind that the Data augmentations have lower priority than the prebuilt pipelines and may get rejected if they overlap during the scheduled pipeline incremental runs. Refer: Activation Scheduled

@User_L2TQS You can add security configurations to secure the subject areas and data with prebuilt and custom duty and data type of application roles. For more details please refer the below document,