Bulk Pick Performance Issue
(Doc ID 2622654.1)
Last updated on DECEMBER 24, 2019
Applies to:
Oracle Warehouse Management Enterprise Edition Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
On : 19.3 version, Core Product Functionality
Bulk Pick Performance Issue
Since Patch 30337607 to fix the error (ORA-01795 Maximum Number Of Expressions.) when executing bulk picking had been deployed to production the time to execute the task has increased dramatically. One batch took 2 hours to pick
NO ERROR -- POOR PERFORMANCE
-----------------------
Performance of Bulk picking is taking over 2 hours to do one batch
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to Execute task
2 Performance is very bad
3. Get error
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 |