My Oracle Support Banner

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

Last updated on MAY 17, 2021

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.


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.


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.