My Oracle Support Banner

COUNT_SNAPSHOT Updated After Selecting Complete Count From the MAF UI (Doc ID 2695287.1)

Last updated on NOVEMBER 04, 2021

Applies to:

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

Symptoms

When a stock count is completed on the SIM MAF UI, the COUNT_SNAPSHOT is updated and the SNAPSHOT_DATE_TIME does not get updated.

Steps to Recreate:

Verify Stock Count parameters:

STOCK_COUNT_SALES_PROCESS_UNIT = 1 (Daily Processing)
STOCK_COUNT_DEFAULT_TIMEFRAME= 1 (Before Store Open)

SIM PC Client

1. Create Unit only Product Group (Auto Authorize = false)
2. Schedule Product Group – 05/05/2020
3. Explode and snapshot on 05/05/2020
4. Sales Batch is imported
5. Posted Late sale for item with sale time stamp as 05/04/2020. Record is inserted in STOCK_COUNT_SALE table and SOH is decremented in STORE_ITEM_STOCK

SIM Mobile (MAF UI)

5. Count item
6. Save
7. Select Complete count.

Late Sale transaction from STOCK_COUNT_SALE table is processed and COUNT_SNAPSHOT is updated automatically when complete count action occurs. Also, SNAPSHOT_DATE_TIME does not get updated.

Changes

 

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
Changes
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.