Process Stock Count Results (STOCKCOUNTPROCESS.KSH) Performs Extremely Slow (Doc ID 2282567.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior  
---------------
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.

Expected Behavior
-----------------------
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.


Changes

 

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