My Oracle Support Banner

Oracle Business Intelligence Publisher Performance Recommendations for Fusion Cloud Applications (Doc ID 2800118.1)

Last updated on JULY 05, 2023

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 11.13.21.10.0 to 11.13.21.10.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.

Purpose

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.

Note: The document is intended for BI system integrators, BI report developers and administrators. It covers advanced performance tuning techniques in BIP and Oracle RDBMS. All recommendations must be carefully verified in a test environment before applied to a production instance.

Scope

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:

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:

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.

Details

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
Purpose
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.