My Oracle Support Banner

Performance Issue With Redirect Link From APCC Dashboard To ADF Order Release Form (Supply Planning Work Area) (Doc ID 2307092.1)

Last updated on AUGUST 19, 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.