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.
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 |