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

Last updated on JUNE 28, 2017

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

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