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

Last updated on MARCH 12, 2021

Applies to:

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.

Changes

Cause

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