POSUPLD Batch Is Updating Stock On Hand In ITEM_LOC_SOH Table For Late Sales After The Stock Count

(Doc ID 1329327.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.0.2 and later
Information in this document applies to any platform.
Checked for relevance as on 02-SEP-16


On late sales, POSUPLD wrongly depletes the stock on hand and also there were no reversal entries posted into TRAN_DATA Table.

Steps To Recreate:

1. Create a  unit & dollar stock count in Store Inventory Management (SIM). 
2. Run STKXPLD.PC batch.
3. Extend vdate to stock take date.
4. Run STKUPD.PC batch.
5. Run STUKUPLD.PC batch.
6. Run STKVAR.PC batch, variance posted into TRAN_DATA Table.
7. Run STKDLY.PC batch.
8. Upload a late sale transaction of any item in the above stock count (sale date should be less than stock take date). Notice that the STOCK_ON_HAND is wrongly reduced by sale qty and no reversal entries are posted into TRAN_DATA Table.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms