FA-SAAS SQL Guardrails for Long-Running BI Reports and Queries (Doc ID 2884584.1)

Last updated on JUNE 06, 2024

Applies to:

Oracle Fusion Project Resource Management Cloud Service
Oracle Fusion Self Service Procurement Cloud Service
Oracle Fusion Financials Common Module Cloud Service
Oracle Fusion Cloud
Oracle Fusion Applications
Information in this document applies to any platform.

Purpose

Pre-built reports, metrics, and dashboards provide the information you need to know, but sometimes you want to see the data a different way. In Oracle Fusion Cloud Applications, we give you the tools to create your own custom reports and queries that meet your specific organizational requirements.

While beneficial, customer-defined reports that are not properly designed and maintained can strain system resources (e.g., database). This has a negative impact on application performance, scalability, and availability. In an effort to maximize the reliability and consistency of your service, we are implementing guardrails that limit the amount of time and resources required to run Business Intelligence (BI) SQL in custom reports. Starting in October 2022, any queries or reports with individual customer-defined BI SQL that exceeds 5 hours or 4 billion logical I/O will be cancelled.