What is the best practice for managing FDI instances while the linked Fusion ERP/SCM instance undergoes patching?
@User_7AIAG , Welcome to the Oracle Analytics Community!
Before scheduled patching to your Fusion ERP/SCM environment, plan and communicate the maintenance schedule with the team that owns your FDI pipelines.
Also, as a best practice, after patching, validate credentials/connectivity. Hope it helps!
@RVohra will the linked FDI instance and relerelevant analytics URL be available during patch activity in ERP/
Hi @User_7AIAG,
Please take a look into the following post which might be useful for the understanding.
Production to Test environment refresh impact on FDI — Oracle
Hope this help.
Thank you.
FDI instances are independent from the Fusion instances they copy data from. There should be no impact on FDI and OAC availability due to Fusion patching and no precautions are documented for before or after the patch.
Hi @User_7AIAG , there are a few different ways to create an FDI instance. It depends on what approach was used for a particular implementation. Oracle recommends integrating FDI directly with the Fusion Applications instance, as it results in a much smoother and more tightly connected setup. With this approach, the FDI instance is automatically linked to Fusion Applications, key application details are prefilled during instance creation, and users can sign in using the same credentials they already use for Fusion. In addition, an integrated FDI setup also allows users, roles, and security groups to be shared between Fusion Applications and FDI, while OAuth is used for authentication across both platforms.
If your deployment is Integrated FDI then it is better to follow the best practice that I had posted before. Thanks
@RVohra Integrated deployment indeed includes SSO, but we can configure SSO even with a detached deployment. The main difference from a user perspective is the use of OAuth for data extraction, which eliminates the need to manage connection credentials. No other functional differences would be experienced.
@Silvio Garber-Oracle , Thanks for providing this information, appreciate it!
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…