My Oracle Support Banner

Poor Performance Updating DBI Dashboards - Unregistered Materialized Views and Known Database Bugs (Doc ID 1510104.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle E-Business Intelligence - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

In E-Business Suite 12.1.2 on a test instance, all concurrent request sets which update Daily Business Intelligence dashboards and reports are running slowly.

Sample timings (h:m:s):

Dashboard Name (Internal Name) INITIAL INCREMENTAL
------------------------------------ -------------------------- ------- ----------------
Receivables Management (FII_AR_MGMT_DASHBOARD) 0:12:15 00:08:06
Receivables Status (FII_AR_STATUS_DASHBOARD)

Customer Fulfillment Management (ISC_DBI_CUST_FULF_MGMT_PAGE) 4:16:24 12:41:25
  
Expense Analysis (FII_EA_EXPENSE_ANALYSIS_PAGE) 0:14:18 00:12:03
Expense Management (FII_EXP_MGMT_PAGE_P)
  
Inventory Management (OPI_DBI_INV_MGMT_PAGE) 3:40:02 35:31:04
  
Product Cost Management (OPI_DBI_PRD_CST_MGMT) 4:49:22 01:01:16
  
Product Revenue Bookings and Backlog (ISC_DBI_REV_BACKLOG_PAGE) 3:04:10 35:21:43
------------------------------------ ---------------------------------------------------- ------- -----------
  TOTALS 16:16:32 84:55:37

The customer is aware of no recent changes which may have caused or affected DBI.

Business impact:
The business is unable to get a current view of data because the results are out of date before the collection has been completed.

Cause

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
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.