My Oracle Support Banner

Last Count Information Incorrectly Updated On STORE_ITEM_STOCK When Stock Count Deleted (Doc ID 2695288.1)

Last updated on AUGUST 23, 2020

Applies to:

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

Symptoms

SIM updates STORE_ITEM_STOCK last count approved information with the partially counted stock count being deleted. Deleting an In-Progress Unit only count with some counted child counts results in incorrect updates of

STORE_ITEM_STOCK.LAST_STK_CNT_TYPE
STORE_ITEM_STOCK.LAST_STK_CNT_APPROVE_DATE
STORE_ITEM_STOCK.LAST_STK_CNT_TIMEFRAME

STORE_ITEM_STOCK.OPEN_STOCK_COUNTS to be decremented with no other updates

Steps to Reproduce:

PC: Create Unit Only Product Group
PC: Schedule Product Group & Explode now

Mobile:

  1. Select Count
  2. Select Snapshot
  3. Select Count
  4. Select Child Count
  5. Enter discrepant counts
  6. Save Child


Note: Data in STOCK_COUNT_LINE_ITEM & STORE_ITEM_STOCK

Mobile:

  1. Select Count (In-Progress)
  2. Menu Delete
  3. Confirm Delete: Yes


Error: Last Stock Count data is incorrectly updated with the In-Progress count

STORE_ITEM_STOCK.LAST_STK_CNT_TYPE
STORE_ITEM_STOCK.LAST_STK_CNT_APPROVE_DATE
STORE_ITEM_STOCK.LAST_STK_CNT_TIMEFRAME

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


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