My Oracle Support Banner

Performance Issue When Trying To Take A Snapshot For A Stock Count Which Has More Than 2 Million Records (Doc ID 1339898.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 13.1 and later
Information in this document applies to any platform.


Store Inventory Management (SIM) has a performance issue when trying to take a snapshot of a stock count with more than 2 million records in the line item table.

Steps to Recreate:

1. Create product group in SIM (unguided, break done by location, 2M of item/zone compilation).
2. Schedule the product group in SIM.
3. Run ExtractStockCount Batch to generate the stock count.
4. Log in to SIM online, find the stock count and then click on 'Take Snapshot' button in stock count location screen.
5. The snapshot process takes more than 2 hours to finish




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.