Sales Received During Stock Count Is Not Working As Expected (Doc ID 3072033.1)

Last updated on FEBRUARY 27, 2025

Applies to:

Symptoms

On : 14.1.3 version, Other

ACTUAL BEHAVIOR
---------------
Sales received during stock count is not working as expected

Client has found that update snapshot of SIM application is not working as expected if sales is received before stock count authorization in SIM.
 

EXPECTED BEHAVIOR
-----------------------
Stock count should be correct

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Scenario : Sales Received after snapshot (but before counted qty was submitted) but counted quantity doesn't consider the sales

1. Identify the item for stock count
2. Create Product Group
3. Create Product Group Schedule
4. Create Stock Count and Take the Snapshot.
5. Create Customer order reservation
6. Process the sales transaction for the customer order
7. Enter the counted qty same as before the start of the stock count (in this example - 8 qty)
8. Verify that if data is inserted in stock_count_sale table or not
9. Go to Authorize the stock count
10. Enter Authorized Qty but do not press Confirm Child
11. Press Update Snapshot button
12. Press Confirm Child
13. complete the stock count
14. validate that Update snapshot button did not change the snapshot qty to 7 and therefore stock on hand remain as 8 instead of 7.

Cause

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