Performance Issue With Redirect Link From APCC Dashboard To ADF Order Release Form (Supply Planning Work Area)
Last updated on SEPTEMBER 13, 2017
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms