Is it possible to create custom report using FDI/BI Publisher which can provide real time data. Is there any option connect BI Publisher to Oracle ERP cloud database directly.
You cannot connect FDI BIP to the Fusion Application Transactional database.
However, you can create reports in FA using BIP and bring that report content into FDI using BIP connector in FDI. You can schedule it to refresh frequently, but it is not real time.
