Stock Counts Purge Batch Is Not Purging Data From The Stock_count_sale Table
(Doc ID 3050640.1)
Last updated on SEPTEMBER 30, 2024
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 24.1 to 24.1 [Release 24.1]Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
Stock counts purge batch is not purging data from the stock_count_sale table
After the batch purges data from the stock count tables stock_count and stock_count_line_item tables, the batch is not purging data from the stock_count_sale table, which ends up generating an accumulation of information in this table.
EXPECTED BEHAVIOR
-----------------------
It is expected that the stock count purge batch job should remove all stock count data that qualifies
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a unit or unit and quantity stock count that has an effective date of the next day (d + 1) and that affects item A.
2. On the day of the count, create a sale of two units for item A.
3. Verify that the sale is reflected in the stock_count_sale table.
4. Cancel the stock count
5. Set the system option "Days To Hold Canceled/Completed Stock Counts" to 1 day.
6. Wait for the next day and verify that the data in the stock_count and stock_count_line_item tables has been deleted.
7. Note that although you do not have entries in the stock_count and stock_count_line_item tables, you still have the stock count sale entry in the stock_count_sale table.
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 |