My Oracle Support Banner

Stock Count Snapshot Not Updating Properly After Adjustments (Doc ID 2506629.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


While performing the adjustments for an open stock count,SNAPSHOT_ON_HAND_QTY not getting updated as per the receipt reversal .

Steps to Reproduce:

  1. Create and approve the purchase order for an item with 10 units approved in 21-Jan-19.
  2. Receive the purchase order by default with 10 units.
  3. Create a stock count with stock_take_date with 23-Jan-19.
  4. Run Stkxpld batch
  5. Advance vdate to stocktake date(23-JAN-2019)
  6. run Stkupd batch and observe that SNAPSHOT_ON_HAND_QTY,SNAPSHOT_IN_TRANSIT_QTY,SNAPSHOT_UNIT_COST is updated to qty which includes the quantity of purchase order receipt.
  7. Advance VDATE to 25th of Jan
  8. Perform RECEIPT UNIT ADJUSTMENT (RUA) and adjust the qty_received as 8, TRAN_DATA  is updated with for the 2 units(10-8 = 2)
  9. Note that the Snapshot on hand is not updated after RUA. Expectation is it has to updated as the stock count is still not processed.
  10. Advance vdate to 26-JAN-2019 and Upload the count file(Late processing of the stock count file) as the PHYSICAL_COUNT_QTY as 6
  11. Run the stockcountupload and stockcountprocess batch.
  12. Advance vdate to 27-JAN-2019 and Create unit_variance_adjustments via front end shows -4 units.
  13. Run Stkvar batch

Expectation: Tran_code 41 should be posted for (6-8) = -2 units. But is instead posted for (6-10) = -4 units and Stock on hand should be 6 units




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.