@fusionenthu , as per my understanding, prune time does not need to match hourly frequency It must protect daily + retry + ingestion latency so with mixed schedules 1440 minutes is ideal Anything ≤ 240 minutes is unsafe for FDI + augmented PVOs. Hope it helps!

@James McBride You are always welcome to log an enhancement request and let Oracle product team review/comment on it.

@fusionenthu , Welcome to the Oracle Analytics Community! For any PVO that ends in ERROR, the “Last Extract Date” is not updated. As a result, the data for those errored PVOs will be re-extracted in the next successful run. Above error indicates that the OTBI / BI Server query timed out while extracting data for specific…

Best practice is to always activate Oracle Fusion Data Intelligence into your Oracle Fusion Cloud Applications account. Doing so saves you time, cost, and complexity when setting up your security integration between Oracle Fusion Data Intelligence and your Oracle Fusion Cloud Applications, as well as improved ongoing…

@User_7AIAG , Welcome to the Oracle Analytics Community! Each FDI environment is a separate OCI deployment, so you will incur OCI consumption costs for: Autonomous Data Warehouse Object Storage OCI Data Integration AI/ML services OCPUs So while there’s no extra FDI license, there is an additional OCI cost per environment.

@Sai Poorna , Welcome to the Oracle Analytics Community! This forum is about Oracle Analytics and related products. You will be better served if you can put your question in General Ledger & Intercompany — Cloud Customer Connect Thanks

Thanks @JimVT for updating this post. @Pritha , as suggested above, please start a new post with your questions. Thanks

There is no practical way to make an HTML BI Publisher report with ~700k rows perform well. As per my understanding, BI Publisher loads the entire XML data set into memory then applies grouping and calculations in the XSLT layer and then renders every row for HTML output and it is all going to be CPU and memory intensive.…

Please refer About Data Access through Security Assignments for more details. Hope it helps!

@James McBride , Welcome to the Oracle Analytics Community! As per my understanding, FDI does not use ERP role/BU security only by default, it uses FDI security contexts and assignments. It means each user must have the FDI data role + an assigned ledger and AP business unit value in FDI for data to populate. Just having…