Performance Issue With Redirect Link From APCC Dashboard To ADF Order Release Form (Supply Planning Work Area)
(Doc ID 2307092.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Advanced Planning Command Center - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Load and Summarization ET in All Instances
Users are on 12.2.5 and have applied patch 22493520 - Mandatory 12.2.5 VCP Consolidated Patch 2 - They are running into an issue where they're in a Business Intelligence APCC dashboard and select and item that will hyperlink them to the Supply Planning Work Area and show release data. However, the first time they go in it takes around 4 minutes for selection to fully show the data. After the first time, it still takes 1 miute 30 to 1 minute 45 seconds to make the jump.
nqquery.log seems to show problem with indexes on table MSC_ORDERS_F
Expect the hyperlink to occur in 10 seconds or less
The issue can be reproduced at will with the following steps:
1. Access APCC dashboards
2. Select item name hyperlink
3. Performance issue occurs waiting for the link to complete
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