My Oracle Support Banner

Approved Date/Count Date Is Not Correct In Stock Count Line Item And Causing SOH Discrepancy (Doc ID 2511507.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


Approved Date/Count date is not correct in stock count line item and causing stock on hand (SOH) discrepancy.
Since stock counted was created on T date, sale processing for T date happened on T+1 date, the sale transaction should reduce the SOH.

Steps to Recreate:

  1. Create a stock count for T date and include all items.
  2. While uploading the stock count, exclude some items which are having SOH in the system but there is no stock in store.
    For example: Item X has stock in the system as more than zero, but zero in the store.
  3. Upload the file on day T+1 and observe that count date time and approved date time are populated with system date (day when upload batch ran).
    Note: Make sure Auto Authorization is ON. So Stock count will be authorized after upload batch completed.
  4. Load the sales for day T, and observe that SOH has not reduced further due to approved date as T+1.




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.