DBI Service Request Backlog Reports Have Bad Performance
(Doc ID 1609143.1)
Last updated on DECEMBER 09, 2020
Applies to:Oracle Service Intelligence - Version 126.96.36.199 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
DBI Service Request Backlog Reports have bad performance.
When drilling down to Service Request Backlog Detail, it takes over 20 minutes and will timeout/freeze before results are retrieved.
We applied a SQL profile and it worked only for the day. Next day back to normal.
The DBI Customer Support Incremental Load request set is running daily and has no errors.
The "BIS Request Set Generator Finalization Program" did take 5 hours to complete.
It should not take more 2 minutes at most.
(R) Daily Customer Support Intelligence
(N) Service Request Backlog Reports
- Choose Customer
- Click on Backlog link for Severity '03 A-Critical'
=> It will error out or freeze after 20 minutes.
First users filter their reports BY CUSTOMER, and then drill down.
With this criteria, Users cannot access the information.
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