PurgeAdHocStockCount Deletes Completed/Approved Stock Count Records

(Doc ID 2116989.1)

Last updated on MARCH 22, 2016

Applies to:

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


In Store Inventory Management, we find that the PurgeAdHocStockCount.sh batch deletes an adhoc stock count that is in status "14 - Approval Complete".

Steps to Recreate:

  1. Using SIM Handheld (HH) UI, create and complete an Adhoc stock count
  2. Using SIM PC UI, complete authorization of the Adhoc stock count
  3. After the number of days specified for the system administration parameter "Days to Hold Completed Stock counts" and "Days to Hold In progress Adhoc Stock counts", run the batch PurgeAdhocStockCounts.sh batch
  4. Find that the above stock count record is deleted from the SIM database table STOCK_COUNT and other related tables


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