My Oracle Support Banner

MSCFNSCW - FIND SUPPLY_DEMAND FORM Very Slow When Selecting A Condition Of AMONG. (Doc ID 2083911.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Using Advanced Supply Chain Planning / Planner's Workbench
On VCP 12.1.3.9.1:
When attempting to perform a query for Items AMONG,
the form takes 2 minutes 26 seconds to build the List of Values (items in the plan) to be used when filling the Find Supply/Demand form. (Note that the results of the query are returned in less than 3 seconds).

EXPECTED BEHAVIOR
-----------------------------------
Expect the List of Values (items in the plan) to be used when filling the Find
Supply/Demand form to complete in a few seconds.

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. (R) Advanced Supply Chain Planner
2. (N) Supply Chain Plan / Workbench
3. View By Actions
4. Plan / DPROD
5. rtClick / Supply and Demand / Supply and Demand

(F) Find Supply/Demand
6. Choose Criteria Item.
7. Choose Condition Among
8. Wait 2 minutes 26 seconds.

Cause

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
Symptoms
Cause
Solution
References


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