[GDEX][PROD] Unable soft allocate for sku- G205631

Question:

Hi CSO team,

Affected Environment:

PROD

Affected warehouse:

WH-HQ

Screenshots of error messages:

Time when issue occurred:

20-24/5/2024 

Affected module:

Shipment Order

Detailed description of issue:

1. All GCOOP orders with SKU G205631 (General Balance Vitamin C) unable to soft allocate.
2. But had tried directly Allocate the orders w/o soft allocate, it succeeded. 

OrderNO
SO240524000084
SO240524000083
SO240524000080
SO240524000079
SO240524000077
SO240524000073
SO240524000072
SO240524000071
SO240524000070
SO240524000069
SO240524000068
SO240524000064
SO240524000063
SO240524000062
SO240523000161
SO240523000105

---

Answer:

Customer did not respond, no amendment is made for other cases.
If similar case happens (unable to soft allocate specific SKU due to the previous SOs that is not properly deleted that can be found in ACT_SOFTALLOCATION_DETAILS table, but not in ACT_ALLOCATION_DETAILS, DOC_ORDER_DETAILS, DOC_ORDER_HEADER tables) 
,
amend the tables for
-INV_LOT (change qtyPreAllocated value)
-ACT_SOFTALLOCATION_DETAILS (delete the specific line)

2 tables involved for soft allocation:
-INV_LOT
-ACT_SOFTALLOCATION_DETAILS

Due to the SOs are deleted when they are still in soft allocated status without performing cancellation of the soft allocation.
We suspect these deletions are done from the backend.
These are the other 29 SOs that we find them in ACT_SOFTALLOCATION_DETAILS table, but not in ACT_ALLOCATION_DETAILS, DOC_ORDER_DETAILS, DOC_ORDER_HEADER tables:
-SO240415005027
-SO220817006500
-DELSO21120707728
-DELSO21120707734
-DELSO21120707737
-DELSO21120707768
-DELSO21120707796
-DELSO21120707811
-DELSO21120707837
-DELSO21120707894
-DELSO21120707949
-DELSO21120707963
-DELSO21120708007
-DELSO21120708094
-DELSO21120708122
-DELSO21120708139
-DELSO21120708189
-DELSO21120708224
-DELSO21120708235
-DELSO21120708272
-DELSO21120708303
-DELSO21120708349
-DELSO21120708370
-DELSO21120708379
-DELSO21120708405
-DELSO21120708415
-DELSO21120708423
-DELSO21120708449
-DELSO21120708464

The latest case of SO deletion was the SO240415005027, which was added and soft allocated by MALINI on 15/4/2024  3:54:53 PM.
This deletion of SO causes the recent soft allocation problem of SKU G205631 and G207253.

We suggest to monitor this issue and if there is a clear pattern on how this is done, we can investigate further on this.
Pending customer's response whether need our help to amend the relevant data for the mentioned list of SOs. (Please refer to the attachment for the details of deleted SOs)

Checking with flux on this

Findings:
Soft allocation fails because the sku INV_LOT.qty > INV_LOT.qtyPreAllocated, then i see backend the qty only 119, and the qtyPreAllocated got 180