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

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.

Symptoms

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

EXPECTED BEHAVIOR
-----------------------
Expect the hyperlink to occur in 10 seconds or less

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

Cause

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