My Oracle Support Banner

Performance issue sorting in SPWA (Doc ID 2651867.1)

Last updated on APRIL 17, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6 to 12.2.6.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Sorting in SPWA

The planners were using SPWA for their daily planning process. In SPWA on the "Supplies and Demands" screen, it takes more than 2 times of duration to sort, compared to Form based application. Eg., for a set of Planned orders in a given Organization takes more than 2 minutes to get the results, when we try to sort in Ascending or descending order in SPWA. Please see the attached screen shot in pdf file.
Please let us know the fix to retrieve the results much faster, since planners use this screen in SPWA for their daily planning.



STEPS
-----------------------
1. Sort on the SPWA
2. takes considerable time

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.