Process Stock Count Results (STOCKCOUNTPROCESS.KSH) Performs Extremely Slow
Last updated on OCTOBER 11, 2017
Applies to:Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.
Process Stock Count Results (STOCKCOUNTPROCESS.KSH) job take an unusually long time to process the files.
For example on a test time observed was 11 hours to consume 240 files (approximately 2 minutes 45 seconds per file).
As another example with one file having 60,000 line items, it took about 21 minutes, whereas its preceding batch, Upload Stock Count Results from Stores/Warehouses (STOCKCOUNTUPLOAD.KSH), took only 5 seconds to process.
Expect STOCKCOUNTPROCESS.KSH to take the same time as that of its preceding batch STOCKCOUNTUPLOAD.KSH for the same volume.
Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Run STOCKCOUNTUPLOAD.KSH with a certain volume of line items (about 60,000).
2. It takes about 5 seconds to complete.
3. Now run the STOCKCOUNTPROCESS.KSH batch.
4. Notice that it takes bout 21 minutes.
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