My Oracle Support Banner

Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)

Last updated on JANUARY 27, 2022

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version and later
Information in this document applies to any platform.


Starting with Fusion Applications Release 20D, two new subject areas are provided to monitor OTBI usage and performance:

For more detailed information, please refer to the What's New Documentation


Steps to Enable

Leverage new subject area(s) by adding to existing reports or using in new reports.

For details about creating and editing reports, see the Creating and Administering Analytics and Reports book (available from the Oracle Help Center > your apps service area of interest > Books > Administration).


Tips And Considerations

OTBI usage subject areas capture each OTBI query execution and related database SQL execution details for six months. 

To ensure better performance, add proper filters to ensure optimal reporting performance.


Key Resources

A sample OTBI Usage Dashboard that demonstrates how to use the two new subject areas is attached to this document.

Attached are two catalog files containing sample dashboard, analysis and filters to demonstrate the new subject areas. 

  1. Download the 2 catalog files.
  2. Read and follow the steps to unarchive the files to the catalog.
  3. Edit "OTBI Usage Dashboard"
  4. Traced the relevant analysis section within Dashboard
  5. Edit relevant OTBI analysis
  6. Select relevant column and go to column properties
  7. Go to Interaction tab and edit Action link
  8. Browse the relevant Analysis/dashboard


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

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