My Oracle Support Banner

Fusion Oracle Transactional Business Intelligence (OTBI) - How To Design OTBI Analyses For Better Performance? (Doc ID 1942331.1)

Last updated on SEPTEMBER 17, 2018

Applies to:

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


This document is intended to provide assistance with the troubleshooting of performance issues encountered whilst running OTBI analyses and dashboards.

These are generic recommendations for OTBI contents.


Copyright © 2018, Oracle. All rights reserved.


This document is provided for information purposes only and the contents hereof are subject to change without notice.


This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied

in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

 Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle

Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Troubleshooting Steps

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
Troubleshooting Steps
 1) Has the performance changed following a patching cycle or environment upgrade ?
 2) Does the performance of the dashboard or analysis change if it is run directly from BI Answers rather than within the Fusion Application ?
 3) Does the same behaviour occur for each user or is the behaviour specific to a certain user of group of users ?
 4) Does the behaviour improve if specific fields are removed from the analysis ?
 5) Does the UI report a Gateway Timeout ?

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