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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.