Oracle Business Intelligence Publisher Performance Recommendations for Fusion Cloud Applications
(Doc ID 2800118.1)
Last updated on OCTOBER 12, 2022
Applies to:Oracle Fusion CX Sales Cloud Service - Version 11.13.20.01.0 and later
Oracle Fusion B2B Service Cloud Service - Version 11.13.21.01.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.20.01.0 and later
Oracle Fusion Financials Common Module Cloud Service - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Oracle Fusion Payables Cloud Service - Version 11.13.22.07.0 to 11.13.22.07.0 [Release 1.0]
Information in this document applies to any platform.
This document covers performance topics and best practices for Oracle Business Intelligence Publisher (BIP) for Fusion Cloud Applications Release 21B and higher. Most of the recommendations are generic for Fusion Applications releases. Release specific topics will refer to exact version numbers.
With Oracle Business Intelligence Publisher (BIP) real time analytic reports, Web Services (WS) data extracts, Oracle Enterprise Scheduler (ESS) flexible schedules, and Oracle Business Intelligence Enterprise Edition (OBIEE) integration, business users have a powerful means for accessing, interpreting and analyzing real-time data in Oracle Fusion Cloud Applications (FA). Users can easily create sophisticated reports with various custom attributes, filters, join conditions, and analytic functions using every single construct offered by Oracle SQL and PL/SQL. Proper design of analytic reports and data integration extracts in BIP is required to ensuring maximum performance and scalability, and to minimum impact on Fusion Middleware and Database resources in FA.
The BIP reports performance can be affected by the following factors:
- Functional requirements for complex calculations and aggregations over large real-time data
- Complex Datamodel design, involving multiple datasets
- Complex SQL logic design of its dataset(s)
- Data security clauses, either explicitly coded in a SQL, or coming from VPD predicates
- Customizations and extensibility attributes
- Web services data extracts and their execution frequency
- Complex data formatting resulting in longer data generation
- Processed data volumes, especially for scheduled integration reports
- Data shape or volume changes that affect optimizer cardinalities estimates
- Changes, such as patches or upgrades, affecting physical data model
- Combination of the mentioned items above.
The attached White Paper will cover each topic in more detail, with examples and recommendations on how to improve the design and to achieve better performance. Many examples will refer to SQL coding options, database query patterns, and SQL query execution paths. The target audience is expected to know SQL basics and to be able to read and understand sample execution plans.
Note, that FA offers more BI tools in its technology stack:
- Oracle Transactional Business Intelligence (OTBI) for quick and convenient custom and ad-hoc BI analysis
- Oracle Business Intelligence Cloud Connector (BICC) for extracting data in CSV output and publishing to Oracle Universal Content Management (UCM) Server or Oracle Storage Service.
Carefully evaluate all offered BI tools and choose the right one to address your functional BI requirements. BI Publisher may not be the best tool for data extracts, as it has enforced memory guards. BICC does not have such guardrails, so it is the primary extraction tool in FA SaaS. Refer to OTBI and BICC Performance Recommendations White Paper published via Doc 2679006.1 for more details on OTBI and BICC usage and recommendations.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document